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