update tbl_1 set wavekey ='XXXX' where current of cur1 我想加条件 update tbl_1 set wavekey ='XXXX' where current of cur1 and wavekey=''and UserID=@userID and flag=0 (这样出错的!)
更新的话也不用游标吧 直接一个 update tbl_1 set wavekey ='XXXX' where wavekey=''and UserID=@userID and flag=0 不就得了,没看到你那里面又跟游标有关系的更新值。
wavekey ='XXXX' 是动态更新的如下: update tbl1 set tbl1.wavekey = tbl1.pickgroupcd + right('0000000000'+Convert(varchar,@cnt-@i),9) where current of cur1
我想加条件
update tbl_1 set wavekey ='XXXX' where current of cur1 and wavekey=''and UserID=@userID and flag=0 (这样出错的!)
直接一个
update tbl_1 set wavekey ='XXXX' where wavekey=''and UserID=@userID and flag=0
不就得了,没看到你那里面又跟游标有关系的更新值。
update tbl1 set tbl1.wavekey = tbl1.pickgroupcd + right('0000000000'+Convert(varchar,@cnt-@i),9) where current of cur1