CREATE trigger test on tablename
for insert
as
declare @test1 varchar(50)
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted
if substring(@test1,1,1) = 't'
insert into table2(test2)values(@test2)
else if substring(@test1,1,1) = 'h'
insert into table3(test3)values(@test3)
end
for insert
as
declare @test1 varchar(50)
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted
if substring(@test1,1,1) = 't'
insert into table2(test2)values(@test2)
else if substring(@test1,1,1) = 'h'
insert into table3(test3)values(@test3)
end
for insert
as
begin
declare @test1 varchar(50)
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted
if substring(@test1,1,1) = 't'
insert into table2(test2) values(@test2)
else
if substring(@test1,1,1) = 'h'
insert into table3(test3) values(@test3)
end
for insert
as
declare @test1 varchar(50)
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted
begin
if substring(@test1,1,1) ='t'
insert into table2(test2) values(@test2)
if substring(@test1,1,1) ='h'
insert into table3(test3) values(@test3)
end
then insert into table2(test2)values(@test2)
then insert into table3(test3)values(@test3)
if substring(@test1,1,1)='t'
....
esle
...
for insert
as
begin
declare @test1 varchar(50)
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted
if substring(@test1,1,1) = 't'
insert into table2(test2) values(@test2)
else if substring(@test1,1,1) = 'h'
insert into table3(test3) values(@test3)
end
declare @test2 varchar(50)
select @test1=abc,@test2=adc from inserted if substring(@test1,1,1) = 't'
begin
insert into table2(test2)values(@test2)
end
else if substring(@test1,1,1) = 'h'
begin
insert into table3(test3)values(@test3)
end
对,用IF 不能用CASE