1:
declare @aa,.....@pp,@qq
select @aa = aa,@bb = bb,@yy = yy form inserted2:如下也可以
if @yy='some'
set @pp=@aa
set @qq=@bb
begin
insert into.....
update......
end3:
declare @aa,.....@pp,@qq
select @pp =aa,@qq = bb form inserted where yy = 'some'
declare @aa,.....@pp,@qq
select @aa = aa,@bb = bb,@yy = yy form inserted2:如下也可以
if @yy='some'
set @pp=@aa
set @qq=@bb
begin
insert into.....
update......
end3:
declare @aa,.....@pp,@qq
select @pp =aa,@qq = bb form inserted where yy = 'some'
begin
---在这里insert into ,update我都可以直接用上面的变量吗?(@pp,@qq)
end