-- =============================================
-- Author: <wangdong>
-- ALTER date: <2010-06-18>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[SendMas]
ON [dbo].[resdd]
for Insert
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @phoneNumber varchar(11) --手机号
declare @matter varchar(100) --短信内容
declare @resdd001 varchar(20) --表单代号
declare @resdd002 varchar(10) --表单单号
declare @resdd007 varchar(10) --员工工号
declare @subject varchar(60)
--取得插入到resdd表的记录
select @resdd001=resdd001,@resdd002=resdd002,@resdd007=resdd007 from inserted
--insert into tbl_log(text1,text2,text3) values(@resdd001,@resdd002,@resdd007)
--取得员工的手机号
select @phoneNumber=resak014 from resak where resak001=@resdd007 if @phoneNumber <> ''
begin
--会议通知
if @resdd001='MTS001'
begin
declare @text1 varchar(20)
declare @text2 varchar(10)
select @text1=mtsta004 from mtsta where (mtsta001=@resdd001) and (mtsta002 = @resdd002)
--select @text1=mtsta004 from mtsta where mtsta001='MTS001' and mtsta002='1006290007'
insert into tbl_log(text1,text2) values(@resdd001,@resdd002)
insert into tbl_log(text1,text2) values(@text1,@text2)
set @matter='公文流转系统有一个任务需要您的审批.'
EXEC send @phoneNumber,@matter
end
end
END上面触发器中的 select @text1=mtsta004 from mtsta where (mtsta001=@resdd001) and (mtsta002 = @resdd002)为什么会取不到值?
-- Author: <wangdong>
-- ALTER date: <2010-06-18>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[SendMas]
ON [dbo].[resdd]
for Insert
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @phoneNumber varchar(11) --手机号
declare @matter varchar(100) --短信内容
declare @resdd001 varchar(20) --表单代号
declare @resdd002 varchar(10) --表单单号
declare @resdd007 varchar(10) --员工工号
declare @subject varchar(60)
--取得插入到resdd表的记录
select @resdd001=resdd001,@resdd002=resdd002,@resdd007=resdd007 from inserted
--insert into tbl_log(text1,text2,text3) values(@resdd001,@resdd002,@resdd007)
--取得员工的手机号
select @phoneNumber=resak014 from resak where resak001=@resdd007 if @phoneNumber <> ''
begin
--会议通知
if @resdd001='MTS001'
begin
declare @text1 varchar(20)
declare @text2 varchar(10)
select @text1=mtsta004 from mtsta where (mtsta001=@resdd001) and (mtsta002 = @resdd002)
--select @text1=mtsta004 from mtsta where mtsta001='MTS001' and mtsta002='1006290007'
insert into tbl_log(text1,text2) values(@resdd001,@resdd002)
insert into tbl_log(text1,text2) values(@text1,@text2)
set @matter='公文流转系统有一个任务需要您的审批.'
EXEC send @phoneNumber,@matter
end
end
END上面触发器中的 select @text1=mtsta004 from mtsta where (mtsta001=@resdd001) and (mtsta002 = @resdd002)为什么会取不到值?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货