帮我看看我的触发器啊:
CREATE TRIGGER AnswerLFH ON dbo.tbSMRecvNotice
FOR INSERT
AS
declare @intCallID int
declare @strCallID varchar(32)
declare @strUserName varchar(20)
declare @strTel varchar(20)
declare @strContent varchar(500)
select top 1 @strCallID=fdcDestAddr,@strTel=fdcSourAddr,@strContent=fdcMessage from tbSMRecvNotice order by fddTime desc
select @strCallID=replace(@strCallID,'075011111','')
if (@strCallID<>'') or (@strCallID is not null)
begin
select @intCallID=convert(int,@strCallID)
end
select @strUserName=Reg_Name from IOA.dbo.JHBJ_Register where Reg_ID=@intCallID
if (@strUserName='') or (@strUserName is not null)
begin
select @strUserName='未知'
end
exec IOA..JHOA_SysSms_insertIn @strTel,@strUserName,@strContent