instead of 触发器
CREATETRIGGERIO_Trig_INS_EmployeeONEmployeeINSTEADOFINSERTASBEGINSETNOCOUNTONIF(NOTEXISTS(SELECTP.SSNFROMPersonP,insertedIWHEREP.SSN=I.SSN))INSERTINTOPersonSELECTSSN,Name,Address,Birthdate,CommentFROMinsertedELSEINSERTINT
下载地址
用户评论
