SQL server 2005 中触发器怎么引用新加入的行

SQL server 2005 中触发器怎么引用新加入的行
--
CREATE TRIGGER ADD_QUESTON
ON TEST_QUESTION
AFTER INSERT
REFERENCES new row nr
AS
BEGIN
x05-- SET NOCOUNT ON added to prevent extra result sets from
x05-- interfering with SELECT statements.
x05SET NOCOUNT ON;
x05x05PRINT 'THANK YOU FOR YOUR ADDITION OF QUESTION!'
x05x05INSERT ADD_QUESTION (TCH_ID,TEST_NUM,ADD_TIME)
x05x05x05SELECT 0000000,TEST_NUM,0000-00-00
x05x05x05FROM TEST_QUESTION
x05x05x05WHERE nr.TEST_NUM=TEST_QUESTION.TEST_NUM
x05x05PRINT 'SUCCESS!'
x05x05PRINT 'THANS!'
x05x05x05
x05x05x05
-- Insert statements for trigger here
END
GO
其中REFERENCES new row nr 出现错误.
wcqqwb 1年前 已收到1个回答 举报

arasi_lan 花朵

共回答了17个问题采纳率:82.4% 举报

--REFERENCES new row nr去掉CREATE TRIGGER ADD_QUESTON ON TEST_QUESTION AFTER INSERT AS BEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET N...

1年前

2
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 16 q. 0.018 s. - webmaster@yulucn.com