Answers were Sorted based on User's Feedback
Answer / saravakumar
Returns the most recently created identity value for the
tables in the current execution scope.
|Is This Answer Correct ?||4 Yes||1 No|
Answer / 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|
What are the main control-of-flow T-SQL constructs?
If we use where clause in the left outer join then how the query would behave/act?
ehat is the default port no of sql 2000?
What types of integrity are enforced by a foreign-key constraint
What is the maximun sixes of .mdf in sql server 2005
How can you see what type of locks used?
How to convert a table data in XML format in sql server?
What is Check point? Explain in Brief what it will do?
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
How to write query to Delete the records in child table and corresponding records in parent table
How to get last system shutdown time in Sql server when restarted system?
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?