E121-17, WITH HOLD cursors


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.