sql指针

--说明：项目中（sql2005/sql2008）的小例子，保存起来供以后自己参考
--声明一个名称为cur的指针
declare cur cursor for select top 5 h.objname,h.objno from humres h;
declare @s varchar(max);
declare @name varchar(10);
declare @no  varchar(10);
set @s = '';
open cur;--打开指针
fetch next from cur into @name, @no;
while (@@FETCH_STATUS = 0)
begin
    set @s = @name + '：' + @no;
    print @s;
    fetch next from cur into @name, @no;--指针下移
end
close cur;--关闭指针
deallocate cur;--释放指针