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 all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What are cursors? Name four types of cursors and when each one would be applied?
How do I compare two values when one value(data type) is char and the other is an integer?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Explain SELF JOIN ?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
how to delete duplicate rows in sql server2005
Diffrence between DTS vs SSIS
How To delete duplicate record from a particular table?
Can you explain some of the DTS problems?
how can i view structure of table in sql server? tell me that query.