Top "Scope-identity" questions

Fetch scope_identity value in C# code from stored procedure in 3 tier architecture

I need to fetch scope_identity() value from a stored procedure after inserting data in C# code. Here I am …

Read More
c# sql-server scope-identity
Will SCOPE_IDENTITY Work in this Case?

I have PK that is self incrementing key. I need to insert the record into the database and then get …

Read More
sql sql-server ado.net scope-identity
Get SCOPE_IDENTITY value when inserting bulk records for SQL TableType

I have following table structure, for convenience purpose I am only marking individual columns Table_A (Id, Name, Desc) Table_1 (…

Read More
sql sql-server bulkinsert scope-identity