Answer Posted / ranjani
Scope_Identity() returns last identity value inserted into
an identity column in the same scope.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
your distribution database is full what will u do
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Explain identity in sql server?
What is read uncmmited?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to delete multiple rows with one delete statement in ms sql server?
List the various tools available for performance tuning?
Please illustrate physical database architecture? : SQL Server Architecture
What are the restrictions while creating batches in sql server?
How to transfer data from a cursor to variables with a "fetch" statement?
Can we use where clause in union?
What is a deadlock and what is a live lock?
What is the difference between SQL notification and SQL invalidation?
What is the full form of dql?
What is the difference between count () and rowcount ()?