Answer Posted / bhupesh
Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is a primary key unique?
What is a partitioned view?
What is the difference between row_number and dense_rank?
What is left outer join in sql server joins?
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
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Explain left outer join and right outer join?
What area unit the various kinds of info compression introduced in sql server 2008?
what are the new features in SSRS?
How do I completely remove sql server instance?
What happens if you add a new index to large table?
What is meant by dirty read?
Ways to improve the performance of a SQL Azure Database?
Differentiate between a primary key and a unique key.
Find first and last day of current month in sql server
