SQL Server cursor usage

---- SQL Server cursor usage
Begin
Declare @ item_code varchar (32) -- define variables
Declare @ item_name varchar (32)
Declare @ invest_money_sum float
-- Define a cursor
Declare my_cursor cursor
For
Select item_code, item_name, invest_money_sum from zftz_project_sheji_result
-- Open the cursor
Open my_cursor
Fetch next from my_cursor into @ item_code, @ item_name, @ invest_money_sum
While (@ fetch_status = 0)
Begin
Update zftz_project_item_info1 set
Mainamount = @ invest_money_sum where code = @ item_code

Fetch next from my_cursor into @ item_code, @ item_name, @ invest_money_sum
Endaa
-- Close the cursor
Close my_cursor
Deallocate my_cursor -- unmount the cursor
End