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

13y

3.3k

1 Active Directory

Answers (7)

Forum Statistics

Please welcome our newest member Nitin Kumar.
2,381,654 users have contributed to 122,515 threads and 389,030
In the past 24 hours, we have 1 new threads, 3 new posts, and 1 new users.
In last week, the most popular thread is 'What's the difference between a DataTable and a DataReader?'.

Upcoming Events

View all

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

Live

How Gen AI is Reshaping Content, Code, and Commerce

C# Scope Identity

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)