Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.