下面有错?总是出现[Microsoft][ODBC SQL Server Driver][SQL Server]无法预定义语句。 SQLSTATE = 37000
create trigger insertemployee on employee after insert as if (select count(*) from inserted where inserted.salary<=1000 or inserted.salary>=100000 )>0 begin print 'please enter a new salary' rollback transaction end 在线等