Sql server database cursor operating summary 02

1.Creating cursor.

Syntax:

DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSOR

FOR SELECT_statement

[FOR {READ ONLY|UPDATE [OF column_name [,...n]]}]

DECLARE hpCamera_DelCursor CURSOR
FOR SELECT * FROM hp_Camera WHERE CameraType=N'球机'
FOR Update

2.Openning Cursor.

Syntax:

OPEN cursor_name

OPEN hpCamera_DelCursor

3.Fetching data from cursor,and Locating DELETE sentence.

Syntax:

FETCH [[fetch_orientation]FROM] cursor_name INTO host_variables

Locating DELETE sentence syntax:

DELETE FROM table_name WHERE CURRENT OF cursor_name

FETCH  FROM hpCamera_DelCursor
DELETE FROM hp_Camera WHERE CURRENT OF hpCamera_DelCursor
FETCH FROM hpCamera_DelCursor
FETCH FROM hpCamera_DelCursor
DELETE FROM hp_Camera WHERE CURRENT OF hpCamera_DelCursor

Figure before operating:

Figure got results:

4.Closing cursor

Syntax:

CLOSE cursor_name

CLOSE hpCamera_UpdCursor