2.4.1.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 11 行

use school
go
create trigger T1 on worker
for insert , update
as 
if (select sage from inserted)<1
begin
print 'Sage must be a integer more than zero! Tansaction fail'
Rollback transaction
End