2.1.1.14 E121, Basic cursor support

  • Article

V0014:

The specification states the following:

 Clause 14, "Data manipulation":
  
 <declare cursor> ::=
 DECLARE <cursor name> <cursor properties>
 FOR <cursor specification>
  
 <open statement> ::=
 OPEN <cursor name>
  
 <fetch statement> ::=
 FETCH [ [ <fetch orientation> ] FROM ] <cursor name> INTO <fetch target list>
  
 <close statement> ::=
 CLOSE <cursor name>
  
 <delete statement: positioned> ::=
 DELETE FROM <target table> [ [ AS ] <correlation name> ]
 WHERE CURRENT OF <cursor name>
  
 <update statement: positioned> ::=
 UPDATE <target table> [ [ AS ] <correlation name> ]
 SET <set clause list>
 WHERE CURRENT OF <cursor name>

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

Transact-SQL partially supports this feature. Transact-SQL partially supports subfeature E121-17 (section 2.1.1.15).