笔试数据库1.doc

fd int

)

create table B(

fa int,

fb int,

fc int,

fd int

)

insert into A values (1,1,1,1);

insert into A values (2,2,2,2);

declare @tempa int,@tempb int,@tempc int;

if (exists(select * from inserted x inner join B y on x.fa=y.fa and x.fb=y.fb))

begin

select @tempa=fa,@tempb=fb,@tempc=fc from inserted;

update B set fc = @tempc where fa = @tempa and fb = @tempb;

end

update A set fc = 345 where fa = 1;

update A set fc = 9090 where fa = 2;

select * from A;

select * from B;