--create table #T (id uniqueidentifier,name nvarchar(50)) --建立临时数据表
select top 2 Id as id,VesselCode as name into #T from Biz_ShipSchedule
declare @id uniqueidentifier ,@name nvarchar(50) --声明变量,需要读取的数据
declare cur cursor static --声明静态游标
for
select * from #T
open cur --打开游标
fetch next from cur into @id,@name --取数据
while(@@FETCH_STATUS=0) --判断是否还有数据
begin
--select '数据:'+RTRIM(@id)+'/'+@name as ds
--insert into #T(id,name)values(@id,@name)
update #T set name='测试' where Id=@id --测试静态动态用
select * from #T
fetch next from cur into @id,@name--这里一定要写取下一条数据
end
close cur --关闭游标
deallocate cur ---撤销游标(释放资源 )
drop table #T
sql server 游标查看
最新推荐文章于 2024-02-24 12:46:44 发布