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
How to attach adventureworkslt physical files to the server?
How many primary keys are possible in a table?
List the data types available in mssql?
What is the difference between sdf and mdf?
What are partitioned views and distributed partitioned views?
How can you fetch alternate records from a table?
what authentication modes does sql server support? : Sql server database administration
What is precedence constraint?
What is a benefit of using an after insert trigger over using a before insert trigger?
What are different types of data sources?
Explain about Joins?
What is data mart? : sql server analysis services, ssas
If we delete pack Spec what will be the status of pack Body ?
What is the difference between Triggers and Stored Procedure?
How to enter binary string literals in ms sql server?