SQL遍历表格数据

最新推荐文章于 2021-12-13 21:02:46 发布

1010骑士

最新推荐文章于 2021-12-13 21:02:46 发布

阅读量554

点赞数

分类专栏： sqlserver

本文链接：https://blog.csdn.net/hgxbra/article/details/53489293

版权

sqlserver 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

--varchar不加长度，默认为varchar(1)
declare @id int, @latitude varchar(20), @longitude varchar(20), @nozonetimes bigint, @devicestatus int, @deviceid varchar(50)
declare @sql varchar(1000)

--创建游标
declare getwplist cursor for  select dp.id,dp.Latitude,dp.longitude,dp.nozonetimes,dp.Devicestatus,dp.Deviceid from DevicePoint dp 

 --开启游标
open getwplist
--读取数据并赋值
fetch NEXT FROM getwplist into @id,@latitude,@longitude,@nozonetimes,@devicestatus,@deviceid

--开始事务
begin TRANSACTION 
-- 表示遇到错误立即回滚
SET XACT_ABORT ON 

--游标读取下一条数据是否成功
WHILE @@FETCH_STATUS = 0 
BEGIN 

   --print 'id='+ cast(@id as varchar) 

   select @sql = 'select * from tt where times <= '+ cast(@nozonetimes as varchar)
   execute(@sql)

   fetch NEXT FROM getwplist into @id,@latitude,@longitude,@nozonetimes,@devicestatus,@deviceid

END

IF @@error <> 0  --发生错误
BEGIN
   ROLLBACK TRANSACTION
END
ELSE
BEGIN
   COMMIT TRANSACTION
END

close getwplist

DEALLOCATE getwplist

...