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 are the advantages of using a stored procedure?
Explain the xml support sql server extends?
What is a bit datatype?
How do you migrate data from mssql server to azure?
How to make remote connection in database?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How to create an index on an existing table in ms sql server?
How to get all stored procedures in sql server?
What is the usage of sign function?
What kind of problems occurs if we do not implement proper locking strategy?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How dts is used to extract, transform and consolidate data?
Can a table have 2 primary keys?
What is triggers and stored procedures?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?