sql server 游标实例

begin
	declare SP cursor for
	    select supcust_no,zip from supcust_temp

	open SP

	declare @supno char(8)
	declare @supzip char(10)

	fetch next from SP into @supno,@supzip
	while @@fetch_status=0
		begin
			update t_bd_supcust_info set zip=@supzip where supcust_no=@supno
			fetch next from SP into @supno,@supzip		
		end			
	close SP
	deallocate SP
end