有表[pro] 字段 UserName,[CurrentPage],[ItemUrl],[PicUrl],[ProdID],[ProcMoney]!
当更新表pro的时候希望建立一个触发器,判断CurrentPage是不是like '%ProdID=%'如果是则提取CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney将其插入表Stop中!
求各位达人有没有办法啊?我不懂触发器,现在项目中用到!急需!
当更新表pro的时候希望建立一个触发器,判断CurrentPage是不是like '%ProdID=%'如果是则提取CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney将其插入表Stop中!
求各位达人有没有办法啊?我不懂触发器,现在项目中用到!急需!
create trigger tr_pro_update
on pro
after update
as
begin
if exists(select * from inserted where CurrentPage like '%ProdID=%')
begin
insert into Stop
select CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney from CurrentPage where CurrentPage like '%ProdID=%'
end
end
for update ,insert
as
insert Stop
select CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney
from inserted
where CurrentPage like '%'+ltrim(ProdID)+'%'
go
as
begin
if exists(select 1 from inserted where CurrentPage like '%ProdID=%')
insert into Stop (CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney) values(select CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney from inserted)
end
on pro
after update
as
begin
insert into Stop
select CurrentPage,ItemUrl,PicUrl,ProdID,ProcMoney from Inserted where CurrentPage like '%ProdID=%'
end