Answer Posted / guest
Do not issue shared locks and do not honor exclusive locks.
When this option is in effect, it is possible to read an
uncommitted transaction or a set of pages that are rolled
back in the middle of a read. Dirty reads are possible. Only
applies to the SELECT statement.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What is the difference between drop table and truncate table?
Explain syntax for viewing, dropping and disabling triggers?
What Are the Main Features of SQL Azure?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
what's the difference between delete table and truncate table commands? : Sql server database administration
Is ssrs support other database except ms sql server?
can you instantiate a com object by using t-sql? : Sql server database administration
How to make a remote connection in a database?
What is the difference between for auto and for nested?
Define self join?
How to delete an existing row with delete statements in ms sql server?
What is executereader?
Does server sql treat char as a variable-length or fixed-length column?
How to find out the list schema name and table name for the database?
What is use of except clause? How does it differ from not in clause?
