USE books management
Go
Declare R_cursor insensitive cursor
For
Select the author, press, book title, number
The from inventory
Where the title='brag skills'
Number for update of the author, press,
The open R_cursor
The fetch absolute 3 from R_cursor
The update inventory
Set the author='ma', press='ali press, number=' 16 '
Where the current of R_cursor
The fetch absolute 3 from R_cursor
The close R_cursor
Deallocate R_cursor
Go
(0 rows affected)
Message 16931, level 16, state 1, line 9
Not line within the current extraction buffer,
The statement has been terminated,
(0 rows affected)