2.1.1.15 E121-17, WITH HOLD cursors

  • Article

V0015:

The specification states the following:

 Subclause 14.1, "<declare cursor>": Where the <value expression> in the <sort key> need not be a <column reference> and need not be in the <select list>, and <cursor holdability> may be specified
  
 <declare cursor> ::=
 DECLARE <cursor name> <cursor properties>
 FOR <cursor specification>
 

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

Transact-SQL partially supports this feature.