小邪  

create trigger tr_table_insertupdate
on tablename
for insert,update
as
if exists (
select 1 from inserted 
where data like '%</script>%'
)
begin
       RAISERROR ('不能修改或者添加',16,1);
       ROLLBACK TRANSACTION
end
go

 

 

posted on 2010-04-01 13:49  小邪  阅读(51)  评论(0)    收藏  举报