CREATE TRIGGER TRI_TEST
ON TB_STUDENT
FOR INSERT
AS
DECLARE @NAME VARCHAR(20)
SELECT @NAME=i.sname FROM inserted i
IF @NAME=‘\0x09‘
BEGIN
raiserror(‘有特殊字符‘,16,8)
ROLLBACK tran
END
本文出自 “斟酒品艰辛” 博客，请务必保留此出处http://andylee.blog.51cto.com/10485636/1748678
原文：http://andylee.blog.51cto.com/10485636/1748678