给你个例子吧。不过附带一句,大资料量游标弊大于利 declare @No varchar(08) declare @sql varchar(1000),@formula varchar(500) declare c1 cursor scroll for select WorkNo from WageInfo open c1 fetch first from c1 into @No while @@fetch_status=0 begin set @formula=(select formula from WageInfo where WorkNo=@No) set @sql='update WageInfo set FactWage=(select '+@formula+' from WageInfo where WorkNo='+@No+') where WorkNo='+@No exec (@sql) fetch next from c1 into @No end close c1 deallocate c1
declare @No varchar(08)
declare @sql varchar(1000),@formula varchar(500)
declare c1 cursor scroll for
select WorkNo from WageInfo
open c1
fetch first from c1 into @No
while @@fetch_status=0
begin
set @formula=(select formula from WageInfo where WorkNo=@No)
set @sql='update WageInfo set FactWage=(select '+@formula+' from WageInfo
where WorkNo='+@No+') where WorkNo='+@No
exec (@sql)
fetch next from c1 into @No
end
close c1
deallocate c1