You want to ensure that statements in the transaction can read rows altered by other transactions even when those transactions have yet to be committed.

Which of the following T-SQL statements can you use to accomplish this task ?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 1524 | Points: 40
Select from following answers:
  1. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
  2. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
  3. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response