Share via


2.1.2.220 T272, Enhanced savepoint management

V0256:

The specification states the following:

 Subclause 11.60, "<SQL-invoked routine>":
  
 <routine characteristics> ::=
 [ <routine characteristic>... ]
  
 <routine characteristic> ::=
 <language clause>
 | <parameter style clause>
 | SPECIFIC <specific name>
 | <deterministic characteristic>
 | <SQL-data access indication>
 | <null-call clause>
 | <returned result sets characteristic>
 | <savepoint level indication>
  
 <savepoint level indication> ::=
 NEW SAVEPOINT LEVEL
 | OLD SAVEPOINT LEVEL
  
 ...
  
 Conformance Rules
  
 Without Feature T272, "Enhanced savepoint management", conforming SQL language shall not contain a <routine characteristics> that contains a <savepoint level indication>.

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

Transact-SQL does not support this feature.