Answer Posted / ranjit
sp_lock to view type of lock applied
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the difference between local and global temporary tables?
What number sorts of privileges are accessible in sql?
How many null values we can have in a unique key field in sql server?
How will you know when statistics on a table are obsolete?
What is database replication?
What is indexing and its types?
What are the purpose of Normalisation?
What is sql server replication? : sql server replication
Differentiate between a primary key and a unique key.
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain the cursor lock types?
How to enter date and time literals in ms sql server?
What is difference between foreign key and unique key?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How to drop an existing table with "drop table" statements in ms sql server?