ALTER TRIGGER AInsertAffter ON kbsys_KB AFTER INSERT,UPDATE ASbegin declare @Keyword Nvarchar(4000) declare @key Nvarchar(4000) declare @t int declare @keyWordCreatedBy Nvarchar(4000) --set @Keyword = inserted.kbKeyWord select @Keyword = kbKeyWord from inserted --set @keyWordCreatedBy = inserted.kbCreatedBy set @t = CHARINDEX(',',@Keyword) if (@Keyword is null) return while(@t <> 0) begin set @key = SUBSTRING(@Keyword,1,@t - 1) set @Keyword = SUBSTRING(@Keyword,@t + 1,len(@Keyword) - @t) if not exists (select * from kbsys_KeyWord where keyWordContent = @key) begin insert into kbsys_KeyWord (keyWordContent,keyWordCreatedBy) select @key,kbCreatedBy from inserted end -- 找下一个逗号 set @t = CHARINDEX(',',@Keyword) end if (@Keyword = '') return if not exists (select * from kbsys_KeyWord where keyWordContent = @Keyword) begin insert into kbsys_KeyWord (keyWordContent,keyWordCreatedBy) select @Keyword,kbCreatedBy from inserted endendposted @ 2008-05-09 17:36 Andrew Yin 阅读(55) 评论(0) 编辑