2.1.1.18 E152, Basic SET TRANSACTION statement

  • Article

V0018:

The specification states the following:

 Subclause 17.2, "<set transaction statement>":
  
 <set transaction statement> ::=
 SET [ LOCAL ] TRANSACTION <transaction characteristics>
  
 Subclause 17.3, "<transaction characteristics>":
  
 <transaction characteristics> ::=
 [ <transaction mode> [ { <comma> <transaction mode> }... ] ]
  
 <transaction mode> ::=
 <isolation level>
 | <transaction access mode>
 | <diagnostics size>
  
 ...
  
 <isolation level> ::=
 ISOLATION LEVEL <level of isolation>
  
 <level of isolation> ::=
 READ UNCOMMITTED
 | READ COMMITTED
 | REPEATABLE READ
 | SERIALIZABLE

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature. Transact-SQL supports all four isolation levels, except for the LOCAL syntax.