sqlserver trigger

--====================================
--  Create database trigger template 
--====================================
USE [EasyJobExTest]
GO

--判断触发器是否存在,存在则删除
IF EXISTS(
  select top 1 t.name as trigger_name,a.name as table_name from sys.triggers t,sys.objects a 
where Lower(a.name)='section' and t.parent_id=a.object_id and Lower(t.name)='tr_section_insert'
)
begin
    DROP TRIGGER tr_section_insert;
end
GO

/*before触发器instead of*/
CREATE TRIGGER tr_section_insert ON section 
    instead of insert,delete,update
    --for delete --after触发器delete
    --for insert --after触发器insert
    --for update --after触发器update
AS 
begin
declare @SecId    int;
declare @SecName    nvarchar(50);
declare @Remark    nvarchar(200);
declare @Department    int;
declare @CreateTime    datetime;
declare @Deepness    int;
declare @ManageUserID    int;

select @SecId=secid,@SecName=t.SecName,@Remark=t.Remark,@Department=t.Department,@CreateTime=t.CreateTime,
@Deepness=t.Deepness,@ManageUserID=t.ManageUserID from inserted t;

if exists(select top 1 * from inserted)
begin
print 'trigger insert'
    IF @CreateTime is NULL
    begin
        select @CreateTime = Sysdatetime()
        print '当前时间：'
        print @CreateTime
    end
        insert into Section values(@SecId,@SecName,@Remark,@Department,@CreateTime,@Deepness,@ManageUserID);
end
else if exists(select top 1 * from deleted)
begin
print 'trigger delete'
end
else
print 'trigger update'

/*
IF IS_MEMBER ('db_owner') = 0
BEGIN
   PRINT 'You must ask your DBA to drop or alter tables!' 
   ROLLBACK TRANSACTION
END
*/
end
go