| 解决方案: |
对每个数据库在查询分析器中运行下列命令,就可以了
declare @s_id int, @u_Name varchar(200), @Act_Tot numeric(28,10), @Act_Tot_0 numeric(28,10)
Declare curMoney Cursor Local Scroll for Select s_id,u_Name,Act_Tot,Act_Tot_0 from moneyaccount Open curMoney Fetch next from curMoney into @s_id,@u_Name,@Act_Tot,@Act_Tot_0 while @@Fetch_Status=0 begin
if (@Act_Tot is null) or (@Act_Tot_0 is null) begin update MoneyAccount set Act_Tot_0=0, Act_Tot=0, Act_Tot_1=0, Act_Hap_1=0, Act_Tot_2=0, Act_Hap_2=0, Act_Tot_3=0, Act_Hap_3=0, Act_Tot_4=0, Act_Hap_4=0, Act_Tot_5=0, Act_Hap_5=0, Act_Tot_6=0, Act_Hap_6=0, Act_Tot_7=0, Act_Hap_7=0, Act_Tot_8=0, Act_Hap_8=0, Act_Tot_9=0, Act_Hap_9=0, Act_Tot_10=0, Act_Hap_10=0, Act_Tot_11=0, Act_Hap_11=0, Act_Tot_12=0, Act_Hap_12=0 where s_id=@s_id end Fetch next from curMoney into @s_id,@u_Name,@Act_Tot,@Act_Tot_0 end Close curMoney deallocate curMoney
|