摘要： 1.触发器方法createTriggerTrigger_NameonTable1afterdelete,UPDATEasbeginsetnocounton;ifexists(select*frominserted)updateTable2setfield1=(selectfield1frominserted)wherefield1=(selectfield1frominserted)elsedeletefromTable2wherefield1=(selectfield1fromdeleted)setnocountoff;end 2. 创建外键关联关系ALTERTABLEtable1ADDCO 阅读全文