KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table Administrator with only one column, adminId which is the primary-key. Because of business rules it has to be this way. I'd like to understand once and for all how I can write stored procedures that insert values in tables like this. I am using SQL Server and T-SQL and tried using SCOPE_IDENTITY() but that doesn't work since the table has INSERT_IDENTITY to false or off. I'd really like to not insert a dummy value just to be able to insert a new row. Thanks!
Tags (comma-separated)
Save Edits
Cancel