How to Get the last identity value used

Answer Posted / j.m.

dbcc checkident(table)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to concatenate two strings in SQL Server.

780


Explain system scalar functions?

744


What are indexes in ms sql server?

715


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

129


What is index fragmentation in ms sql server?

769






Explain nested stored procedure. Syntax and an example for create nested stored procedure?

689


How to connect Azure federated root database and apply federation in entity framework?

101


how to avoid cursors? : Sql server database administration

652


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

727


What is the sql case statement used for? Explain with an example?

709


What do you understand by coalesce in sql server?

719


How to get a list of columns in a view using the "sp_columns" stored procedure?

788


What is a cursor, index in sql?

769


How to optimize stored procedures in sql server?

826


When would you use it?

756