用 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
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
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)
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)
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--这样就可以了