CREATE TRIGGER TRI_T ON T
FOR INSERT
AS
BEGIN
SELECT COUNT(*) FROM T,inserted WHERE T.C_NAME=inserted.C_NAME
IF @@ROWCOUNT>0
RAISERROR('HAVE RECORD',16,1)
ELSE
RAISERROR('NO RECORD',16,1)
END
FOR INSERT
AS
BEGIN
SELECT COUNT(*) FROM T,inserted WHERE T.C_NAME=inserted.C_NAME
IF @@ROWCOUNT>0
RAISERROR('HAVE RECORD',16,1)
ELSE
RAISERROR('NO RECORD',16,1)
END
FOR INSERT
AS
BEGIN
SELECT COUNT(*) FROM T,inserted WHERE T.C_NAME=inserted.C_NAME
IF @@ROWCOUNT>0
RAISERROR('HAVE RECORD',16,1)
ELSE
RAISERROR('NO RECORD',16,1)
END
是不是複製的??????????????????