这是代码exec('declare my_cursor1 cursor for select BctID,OrderProcessID from FP_ScenicTicketsBook where OrderProcessID=''295855''') open my_cursor1 declare @id1 sysname declare @id2 sysname fetch next from my_cursor1 into @id1,@id2 while(@@fetch_status= 0) begin set @BctID =convert(varchar(32),@id1) set @OrderProcessID =convert(varchar(32),@id2) fetch next from my_cursor1 into @id1,@id2 end close my_cursor1 deallocate my_cursor1
update 表 set 列=0.0 where 条件这样就一次都改成0.0了,重点是where条件的筛选
open my_cursor1
declare @id1 sysname
declare @id2 sysname
fetch next from my_cursor1 into @id1,@id2
while(@@fetch_status= 0)
begin
set @BctID =convert(varchar(32),@id1)
set @OrderProcessID =convert(varchar(32),@id2)
fetch next from my_cursor1 into @id1,@id2
end
close my_cursor1
deallocate my_cursor1
set 列=0.0
where 条件这样就一次都改成0.0了,重点是where条件的筛选