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 is 1nf 2nf?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the significance of master, tempdb and model databases?
What is create statement?
How do you debug a procedure in sql server?
Which is faster statement or preparedstatement?
What is the log shipping?
Explain about unique identifier data type in sql server?
How you provide security to cube? : sql server analysis services, ssas
What is the difference between createstatement and preparedstatement?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Can foreign key be deleted?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to delete duplicate records based on single column from a table?
How to rebuild the master database?
