触发器

USE [YsFreight_New]
GO
/****** Object:  Trigger [dbo].[tgr_classes_insert]    Script Date: 04/25/2017 10:21:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[tgr_classes_insert]
on [dbo].[Sys_Organize]
    for insert --插入触发
as
    --定义变量
    declare @F_Id varchar(100), @F_CategoryId varchar(100), @DeptCode varchar(100),@DeptName varchar(100);
    --在inserted表中查询已经插入记录信息
    select @F_Id = F_Id, @F_CategoryId = F_CategoryId,@DeptCode=F_EnCode,@DeptName=F_ShortName from inserted;
     if(@F_CategoryId)= 'Department'
    insert into TEIDept values(@F_Id, @DeptCode, @DeptName);