2.1.2.215 T231, Sensitive cursors

  • Article

V0251:

The specification states the following:

 Subclause 14.2, "<cursor properties>":
  
 <cursor properties> ::=
 [ <cursor sensitivity> ] [ <cursor scrollability> ] CURSOR
 [ <cursor holdability> ]
 [ <cursor returnability> ]
  
 <cursor sensitivity> ::=
 SENSITIVE
 | INSENSITIVE
 | ASENSITIVE
  
 ...
  
 Conformance Rules
  
 Without Feature T231, "Sensitive cursors", conforming SQL language shall not contain a <cursor sensitivity> that immediately contains SENSITIVE.
  
 ...
  
 Without Feature F791, "Insensitive cursors", or Feature T231, "Sensitive cursors", conforming SQL language shall not contain a <cursor sensitivity> that immediately contains ASENSITIVE.

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

Transact-SQL does not support this feature.