Deleting Rows in Result Sets

The ADO, OLE DB, and ODBC application programming interfaces (APIs) support deleting the current row that an application is positioned on in a result set. The application executes a statement, and then fetches rows from the result set. After an application has fetched the row, it can use the following functions or methods to delete the row:

Transact-SQL scripts, stored procedures, and triggers can use the WHERE CURRENT OF clause on a DELETE statement to delete the cursor row on which they are currently positioned, for example:

DECLARE abc CURSOR FOR

  SELECT * FROM MyTable

  

OPEN abc

  

FETCH NEXT FROM abc

  

DELETE MyTable WHERE CURRENT OF abc

  

CLOSE abc

  

DEALLOCATE abc

  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.