Create Trigger trg_Delete 
On A
For Delete 
As
Delete B where B.章节码 in (select 章节码 from Deleted)
Return

解决方案 »

  1.   

    try:Create Trigger trg_Delete 
    On A
    For Delete 
    As
    Delete 
    From  B
    Where B.章节码 in(select  章节码 from Deleted)
      

  2.   

    Create Trigger trg_Delete 
    On A
    For Delete 
    As
    begin
    Delete 
    From  B,Deleted
    Where B.章节码 = Deleted.章节码
    end
      

  3.   

    Create Trigger trg_Delete 
    On A
    For Delete 
    As
        delete B from B, DELETED c where B.章节码 = c.章节码
    Return
      

  4.   

    Create Trigger trg_Delete 
    On A
    For Delete 
    As
        delete B from B, DELETED c where B.章节码 = c.章节码
    Return