declare my_cur1 cursor for
select projectcode from prjm_project
begin
declare @projectcode varchar(20)
open my_cur1
fetch my_cur1 into @projectcode
while(@@sqlstatus = 0)
begin
print @projectcode
fetch my_cur1 into @projectcode
end
close my_cur1
deallocate cursor my_cur1
end
注:要先执行declare my_cur1 cursor for
select projectcode from prjm_project 然后再执行下面所有的