不能在结尾加引号";"//tb_backupWHERE id = @id;2.if @SourceTb='tb_card'
exec (pre_card @id)
if @SourceTb='tb_user'
exec(pre_user @id)
if @SourceTb='tb_consume'
exec(pre_consume @id,@goalTb)END
exec (pre_card @id)
if @SourceTb='tb_user'
exec(pre_user @id)
if @SourceTb='tb_consume'
exec(pre_consume @id,@goalTb)END
select substring('test', 1, 1) --suceess
要这么说,我上面的只能不多个if才可以实现了????
exec(prs_card @id)
else if @SourceTb = 'tb_user'
exec(prs_user @id)
else if @SourceTb = 'tb_consume'
exec(prs_consume @id,@GoalTb)
else if @SourceTb = 'tb_saving'
exec(prs_dayTerminal @id,@GoalTb)
else if @SourceTb = 'tb_dayTerminal'
exec(prs_saving @id,@GoalTb)