How to WHERE CURRENT OF clause?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 2335
Syntax
WHERE CURRENT OF cursor-Name

Comments or Responses

Posted by: Rajni.Shekhar on: 4/18/2012 Level:Bronze | Status: [Member] | Points: 10
Can you please share what is WHERE CURRENT OF ???
Posted by: Sabarimahesh on: 4/19/2012 Level:Bronze | Status: [Member] | Points: 10
The WHERE CURRENT OF clause is a clause in some UPDATE and DELETE statements. It allows you to perform positioned updates and deletes on updatable cursors. For more information about updatable cursors, see SELECT statement.

Login to post response