Answer Posted / chandramohan
scope_identity() would be the currect answer. To avoid potential problems professionals suggests this method since it returns the recently added value.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What does it mean to invest in the index?
Can we hide the definition of a stored procedure from a use?
What are the properties of the transaction?
How will you hide an attribute? : sql server analysis services, ssas
What is cursors? And what are the different types of cursor?
How exceptions can be handled in sql server programming?
What is difference between index seek vs. Index scan?
What happens when converting big values to integers?
How can you know if the row fetched from cursor is still valid in underlying table?
What is a matrix in ssrs?
Explain multiserver query
What is the difference between commit and rollback?
When I delete any data from a table, does the sql server reduce the size of that table?
What are the disadvantages of using the stored procedures?
How to override dml statements with triggers?