CREATE TRIGGER tr_A_Update ON A FOR UPDATE AS declare @str varchar(2000) declare @pos int if inserted.state='YES' begin select @str = dept from inserted select @pos = CHARINDEX( ',',@str ) while ( @pos>0 ) begin insert B(name) select substring(@str,3,@pos-3) select @str = right(@str,len(@str)-@pos) select @pos = CHARINDEX( ',',@str ) end if len(@str)>0 insert B(name) select right(@str,len(@str)-2) end
ON A
FOR UPDATE
AS
declare @str varchar(2000)
declare @pos int
if inserted.state='YES'
begin
select @str = dept from inserted
select @pos = CHARINDEX( ',',@str )
while ( @pos>0 )
begin
insert B(name)
select substring(@str,3,@pos-3)
select @str = right(@str,len(@str)-@pos)
select @pos = CHARINDEX( ',',@str )
end
if len(@str)>0
insert B(name)
select right(@str,len(@str)-2)
end