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