Answer Posted / guest
the last identity value used in an insert can be retrieved
with the @@identity function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the main differences between #temp tables and @table variables and which one is preferred?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How do I view views in sql server?
What is tabulation?
Do you know how to store and query spatial data?
Difference between connected and disconnected database in .net with sql server?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is microsoft sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Can sql servers link to other servers like oracle?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Which data type columns are the best candidates for full-text indexing?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is the use of tempdb? What values does it hold?
How to delete duplicate records based on single column from a table?