Retrieve SCOPE_IDENTITY() value in SQL Server

String sqlInsert = “insert into TableName(colA,ColB) values(@colA,@ColB); select SCOPE_IDENTITY();”;

command.CommandText = sqlInsert;
command.Parameters.Clear();
command.Parameters.AddWithValue(“@colA“, valA);
command.Parameters.AddWithValue(“@colB, valB);

Object autoIdValue = command.ExecuteScalar();

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s