首页CREATE TRIGGER PreventEndDateUpdate12345 ON Questionnaire FOR UPDATE AS BEGIN IF UPDATE(EndDate) BEGIN IF EXISTS (SELECT * FROM inserted WHERE EndDate < GETDATE()) BEGIN RAISERROR('Cannot set EndDate to a past date.', 16, 1); ROLLBACK; END END END;

CREATE TRIGGER PreventEndDateUpdate12345 ON Questionnaire FOR UPDATE AS BEGIN IF UPDATE(EndDate) BEGIN IF EXISTS (SELECT * FROM inserted WHERE EndDate < GETDATE()) BEGIN RAISERROR('Cannot set EndDate to a past date.', 16, 1); ROLLBACK; END END END;

时间: 2024-04-27 18:20:51 浏览: 60

A special scoring procedure for minimizing response bias on the school anxiety questionnaire

A special scoring procedure for minimizing response bias on the school anxiety questionnaire 210 JAMES A. DUNN REFERENCES BEROAN, J. R. Viezcal imagery and r e d achievemat. Paper presented at the American Educational BERGAN, J. R. A special scoring procedure for minimizing response bias on the School Anxiety DUNN, J. A. Factor structure of the test anxiety scale for children. Journal of Conaulting Psychology, DUNN, J. A. Age and sex differences in the factor structure of the test a

这是一个 SQL Server 数据库中的触发器（Trigger），它的名称是 PreventEndDateUpdate12345，作用于 Questionnaire 表的 UPDATE 操作。当更新操作包含 EndDate 字段时，该触发器会判断新值是否小于当前时间，如果是则触发错误提示，并回滚该更新操作，防止结束时间被设置为过去的时间。这个触发器的目的是确保问卷的结束时间不会被无意间或者恶意地修改为过去的时间。

阅读全文