Answer Posted / ranjani
Scope_Identity() returns last identity value inserted into
an identity column in the same scope.
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How to delete exactly duplicate records from a table?
What type of locking occurs during the snapshot generation? : sql server replication
How to write a query with a full outer join in ms sql server?
How do I create a trace in sql server?
What are the different types of upgrades that can be performed in sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How dts is used to extract, transform and consolidate data?
What are the commands used in DCL?
can an order by clause be used in a creation of a view?
what are different types of raid configurations? : Sql server database administration
Explain Reporting Life Cycle?
What is normalization and its types?
Explain system functions or built-in functions? What are different types of system functions?
What is a transaction and why is it important?