Answer Posted / Mohit Singh Chauhan
SQL Server provides several cursor lock types to control the level of concurrency and isolation during cursor operations. The available lock types are:
1. READ_UNCOMMITTED: Allows dirty reads, non-repeatable reads, and phantom reads.
2. READ_COMMITTED: Prevents dirty reads but allows non-repeatable reads and phantom reads.
3. REPEATABLE_READ: Prevents non-repeatable reads but allows phantom reads.
4. SERIALIZABLE: Prevents both non-repeatable reads and phantom reads, ensuring serializable isolation level.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to remove duplicate rows from table except one?
What is temporary table in sql server? Why we use temp table?
What is normalization and what are the advantages of it?
What is a view in sql?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What kind of problems occurs if we do not implement proper locking strategy?
What is acid mean in sql server?
Explain system functions or built-in functions? What are different types of system functions?
Why use identity in sql server?
Why we use the openxml clause?
What are different types of constraints?
What is in place upgrade in sql server?
What are the properties of the transaction?
How raid can influence database performance?
What is sql server query analyzer?
