td_cwfx_deptbudgetmaster.txt

来自「财务分析 财财务分析务分析」· 文本 代码 · 共 34 行

/* ============================================================ */
/*   Database name:  财务分析                                   */
/*   DBMS name:      Microsoft SQL Server 2000                   */   
/*   Author name:    魏永生                                     */
/*   Created on:     2001-8-2  15:41                            */
/* ============================================================ */

/*  Delete trigger "td_cwfx_deptbudgetmaster" for table "cwfx_DeptBudgetMaster"  */
create trigger td_cwfx_deptbudgetmaster on cwfx_DeptBudgetMaster for delete as
begin
    declare
       @numrows  int,
       @errno    int,
       @errmsg   varchar(255)

    select  @numrows = @@rowcount
    if @numrows = 0
       return


    /*  Delete all children in "cwfx_DeptBudgetSlaver"  */
    delete cwfx_DeptBudgetSlaver
    from   cwfx_DeptBudgetSlaver t2, deleted t1
    where  t2.I_Id = t1.I_Id

    return

/*  Errors handling  */
error:
    raiserror @errno @errmsg
    rollback  transaction
end