SELECT Ident_Current('dbo. MyTable' ) Hope It Helped. Please Check This is Currect Answer .

Do one thing Can u do like this string sqlStatement = InsertQuery + ";SELECT SCOPE_IDENTITY()"; Even this will work. Hope It Helped. Please Mark answer as Accepted Answer .

Scope_Identity returns the identity value inserted in the current scope(regardless of a table) and a scope means a module,stored procedure,trigger,function or batch. (In your case you will get value as 0 as there are no changes in identity column in current scope). To achieve what u want 1.You can use @@Identity which returns Identity value inserted regardless of the table and scope(so it may help) 2.Ident_Current('tableName') which return the last identity value generated for a specific table in any session and scope. 3.Create Stored Procedure and put your insert query followed by Select Scope_Identity() and front end execute Stored Procedure using the same syntax. Hope It Helped. Please Mark answer as Accepted Answer .

Answers

C# Scope Identity

bagzli

12y

3.7k

Answers (7)

Next Recommended Forum

Need regex code to replace a particular variable name in an expression by some value.

While loop & ||

Forum Statistics

Please welcome our newest member mike1880 .
3,090,464 users have contributed to 147,410 threads and 483,576
In the past 24 hours, we have 2 new threads, 3 new posts, and 142 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all

Advancing into the Future with IT
Live Discussion on Startups, AI, and Career Growth
Streamlined Purchase Order Approval for Finance Teams: Automate Your Business Processes - Ep.7