触发器 问题

[agefworld]

CREATE trigger insert_Date on test
for insert
as
declare @id int,@title varchar(50),@content varchar(5000) --根据实际情况设置大小
select @id =id,@title=title,@content=content from test
if @content='aa'
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test',@title,@content)
else
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test1',@title,@content)

我想通过输入不同的值，触发不同的结果，可是无论怎样，都是第二个，哪里有问题么？

[1x1y]

用 where 判断
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test1',@title,@content) where 1

insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test1',@title,@content) where 2

[pengdali]

CREATE trigger insert_Date on test
for insert
as
declare @id int,@title varchar(50),@content varchar(5000) --根据实际情况设置大小
select @id =id,@title=title,@content=content from inserted
if @content='aa'
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test',@title,@content)
else
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test1',@title,@content)

[mjhnet]

--不过要保证每次只插入一条记录才行
CREATE trigger insert_Date on test
for insert
as
declare @id int,@title varchar(50),@content varchar(5000) --根据实际情况设置大小
select @id =id,@title=title,@content=content from inserted
if @content='aa'
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test',@title,@content)
else
insert into result(res_id,res_tbl,res_title,res_content) values(@id,'test1',@title,@content)

[pengdali]

CREATE trigger insert_Date on test
for insert
as
insert result(res_id,res_tbl,res_title,res_content) select id,case when content='aa' then 'test' else 'test1' end,title,content from inserted
go

--这样就可以了