摘要:
基本语句如下﹕createtriggertrigger_nameon{table_name|view_name}{for|After|Insteadof}[insert,update,delete]assql_statementaaa实例:createtriggercmdinsertedonctrdevcmdsforinsertasdeclare@idnumeric(15,0)select@id=idfrominserted update ctrdevcmds set send_time=GETDATE(),back_time=GETDATE(),status='2' wher 阅读全文