游標使用方法： use db1 declare my_cursor cursor scroll dynamic /*scroll表示可隨意移動游標指針（否則只能向前），dynamic表示可以讀寫游標（否則游標只讀）*/ for select 姓名 from 個人資料
open my_cursor declare @name sysname fetch next from my_cursor into @name while(@@fetch_status=0) begin print '姓名: ' + @name fetch next from my_cursor into @name end fetch first from my_cursor into @name print @name /* update 個人資料 set 姓名='zzg' where current of my_cursor */ /* delete from 個人資料 where current of my_cursor */ close my_cursor deallocate my_cursor 正文
