这个是我的代码 提示 FROM 周围有错误 求解 谢谢了
- SQL code
CREATE TRIGGER TRI_NAME_DEL ON tblStudent FOR DELETE ASDECLARE @towcount intSET @towcount= COUNT(*) from DELETED if @towcount>2ROLLBACK TRANSACTIONprint 'you cannot delete more than one student at a time!'END
------解决方案--------------------
- SQL code
CREATE TRIGGER TRI_NAME_DEL ON tblStudent FOR DELETE asbeginDECLARE @towcount intselect @towcount= COUNT(*) from DELETED if @towcount>2begin ROLLBACK TRANSACTION print 'you cannot delete more than one student at a time!'endEND