sql 触发器 NTEXT TEXT IMAGE 无法写入的问题 二进制来做

instead of  insert,update,delete   以前写的是after =instead of  改这样直接二进制来做

USE [testOAone]

GO
/****** Object:  Trigger [dbo].[tgr_FileMailData]    Script Date: 09/23/2015 14:32:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO






ALTER trigger [dbo].[tgr_FileMailData]
on [dbo].[FileMailData]
instead of  insert,update,delete
as
declare @RecUser varchar(8000)
declare @SenderStreetName nvarchar(4000)
declare @SenderGroupName nvarchar(4000)
declare @SenderSectionOffice nvarchar(4000)
declare @SenderID nvarchar(200)
declare @MailTit nvarchar(MAX)
declare @MailText nvarchar(MAX)
declare @SendTime nvarchar(4000)
declare @EFName  nvarchar(4000)
declare @CFName nvarchar(4000)
declare @UserIP nvarchar(4000)
declare @RecUserBak nvarchar(MAX)
declare @RecUserBakID nvarchar(MAX)
declare @OverRead nvarchar(MAX)
declare @OverReadID nvarchar(MAX)
declare @OverRec nvarchar(MAX)
declare @FileClass char(10)
declare @MailState nvarchar(200)
declare @ExamineState int
declare @ExamineType int
declare @ExamineContent nvarchar(MAX)
declare @ReadUser nvarchar(MAX)
declare @Word varchar(200)
declare @WordNO varchar(200)
declare @DraftDepartment varchar(200)
declare @DraftMan varchar(200)
declare @STime datetime
declare @ETime datetime
declare @DBZT varchar(50)
declare @SFDB varchar(50)
declare @BETime datetime


 select @RecUser=RecUser,@SenderStreetName=SenderStreetName,@SenderGroupName=SenderGroupName,
        @SenderSectionOffice=SenderSectionOffice,@SenderID=SenderID,@MailTit=MailTit from inserted
 select @RecUser=RecUser,@SenderStreetName=SenderStreetName,@SenderGroupName=SenderGroupName from deleted
 select @RecUser=RecUser,@SenderStreetName=SenderStreetName,@SenderGroupName=SenderGroupName from updated
    if (exists (select 1 from inserted) )
    begin
        insert into [testOAtwo].[dbo].DZM_FileMailData(RecUser,SenderStreetName,SenderGroupName) 
        values(@RecUser,@SenderStreetName,@SenderGroupName);
    end
    else if (exists (select 1 from deleted))
    begin
        insert into [testOAtwo].[dbo].DZM_FileMailData(RecUser,SenderStreetName,SenderGroupName) 
        values(@RecUser,@SenderStreetName,@SenderGroupName);
    end
    else if (exists (select 1 from updated))
    begin
       insert into [testOAtwo].[dbo].DZM_FileMailData(RecUser,SenderStreetName,SenderGroupName) 
        values(@RecUser,@SenderStreetName,@SenderGroupName);
    end