触发器

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
 GO
 -- =============================================
 -- Author:  <Zidane>
 -- Create date: <9/26/2011>
 -- Description: <Create a triger for F_File_Info so that 
--     F_File_Path can update with it synchronize>
 -- =============================================
 CREATE TRIGGER triggerFileInfo
    ON  F_File_Info
    AFTER DELETE
 AS 
BEGIN
  DELETE F_File_Path WHERE F_File_MD5 IN
  (SELECT F_File_MD5 FROM deleted)
 END

给F_File_Info表插入一个触发器，使得在对这个表进行删除操作后也对F_File_Path进行一个删除操作。

感觉就是对数据库进行了封装，降低了数据库操作跟程序代码的耦合度，也实现了代码的重用性。