SQL遍历表格数据

来源：互联网发布：mysql rank over 编辑：程序博客网时间：2024/04/29 08:47

--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,@deviceidENDIF @@error <> 0  --发生错误BEGIN   ROLLBACK TRANSACTIONENDELSEBEGIN   COMMIT TRANSACTIONENDclose getwplistDEALLOCATE getwplist

...

0 0