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

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

714


Define right outer join in sql server joins?

513


What is the security principal at the database level that represents your session?

538


Give a example to search fr a string in all stored procedure in sql server.

530


How to get a list of columns using the "sys.columns" view in ms sql server?

556






Relational calculus is what type of language?

573


Explain the use of containers in ssis?

524


What is self join in sql server joins?

554


What does truncate do?

531


How to find index size for each index on table?

581


How to Sync Two SQL Azure Databases?

101


Difference between Logical Page and Physical Page in SSRS.

339


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

595


What is extent? Types of extents?

585


What's the information that can be stored inside a bit column?

540