Answer Posted / bhupesh
Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain an incremental backup?
How do I view a stored procedure in sql server?
What are the events recorded in a transaction log?
Explain different types of index?
What is system stored procedures?
what's the maximum size of a row? : Sql server database administration
What are wait types?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are Spatial data types in SQL Server 2008
List out the different types of locks available in sql server?
What is the command to change the recovery model?
What are the ways available in sql server to execute sql statements?
How is table type constraint applied to a table?
Explain tables in SQL Azure?
What is collation sensitivity? Explain different types.