触发器写的有问题。 alter trigger my_trig on A for insert as begin insert into B select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted insert into c values(@callnum ,@key , getdate()) select callnum,[key],getdate() from inserted delete from a where callnum in(select callnum from inserted) end
dawugui大神,我已经加了自增ID列还是没解决怎么办啊? 请问Dlut_LIuQ应该怎么办呢?
你修改下触发器 alter trigger my_trig on A for insert as begin insert into B select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted insert into c select callnum,[key],getdate() from inserted delete from a where callnum in(select callnum from inserted) end
--应该还得判断callnum在A表中是否存在的情况。 --没插入一条的时候都得判断用户是否重复。
Dlut_LIuQ 写的有问题吧,连变量都没的么?
请问我原来这个 CREATE trigger my_tri on dbo.CA for insert as begin declare @callnum as varchar(20) declare @key as varchar(20) select @callnum = callnum from inserted select @key = [key] from inserted INSERT INTO SGIP12_SUBMIT (MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType, FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid, TP_udhi, MessageCoding, MessageType, MessageContent) VALUES (0, 'XXXX', @callnum, @callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1, 0, 0, 15, 0, 'XXX' + @key + ',XXX') insert into CA_HISTORY values(@callnum ,@key , getdate()) delete from CA where callnum = @callnum end 应该怎么改成 alter trigger my_trig on A for insert as begin insert into B select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted insert into c select callnum,[key],getdate() from inserted delete from a where callnum in(select callnum from inserted) end
CREATE trigger my_tri on dbo.CA for insert as beginINSERT INTO SGIP12_SUBMIT (MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType, FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid, TP_udhi, MessageCoding, MessageType, MessageContent) select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1, 0, 0, 15, 0, 'XXX' + key + ',XXX' from inseted insert into CA_HISTORY select callnum ,key , getdate() from inseted delete from CA where callnum in(select callnum from inserted) end
CREATE trigger my_tri on dbo.CA for insert as beginINSERT INTO SGIP12_SUBMIT (MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType, FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid, TP_udhi, MessageCoding, MessageType, MessageContent) select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1, 0, 0, 15, 0, 'XXX' + key + ',XXX' from inseted insert into CA_HISTORY select callnum ,key , getdate() from inseted delete from CA where callnum in(select callnum from inserted) end
错误165,在关键字key附近有语法错误! 肯请 Dlut_LIuQ 给出无错语句,谢谢!
CREATE trigger my_tri on dbo.CA for insert as beginINSERT INTO SGIP12_SUBMIT (MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType, FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid, TP_udhi, MessageCoding, MessageType, MessageContent) select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1, 0, 0, 15, 0, 'XXX' +[key] + ',XXX' from inserted insert into CA_HISTORY select callnum ,[key] , getdate() from inserted delete from CA where callnum in(select callnum from inserted) end
alter trigger my_trig on A for insert
as
begin
insert into B
select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted
insert into c values(@callnum ,@key , getdate())
select callnum,[key],getdate() from inserted
delete from a where callnum in(select callnum from inserted)
end
alter trigger my_trig on A for insert
as
begin
insert into B
select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted
insert into c
select callnum,[key],getdate() from inserted
delete from a where callnum in(select callnum from inserted)
end
--应该还得判断callnum在A表中是否存在的情况。
--没插入一条的时候都得判断用户是否重复。
CREATE trigger my_tri on dbo.CA for insert
as
begin
declare @callnum as varchar(20)
declare @key as varchar(20)
select @callnum = callnum from inserted
select @key = [key] from inserted
INSERT INTO SGIP12_SUBMIT
(MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType,
FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid,
TP_udhi, MessageCoding, MessageType, MessageContent)
VALUES (0, 'XXXX', @callnum, @callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1,
0, 0, 15, 0, 'XXX' + @key + ',XXX')
insert into CA_HISTORY values(@callnum ,@key , getdate())
delete from CA where callnum = @callnum
end
应该怎么改成
alter trigger my_trig on A for insert
as
begin
insert into B
select callnum,[key],'尊敬的' + callnum + '用户','您的密码是' + [key] + ',感谢您使用此业务!' from inserted
insert into c
select callnum,[key],getdate() from inserted
delete from a where callnum in(select callnum from inserted)
end
as
beginINSERT INTO SGIP12_SUBMIT
(MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType,
FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid,
TP_udhi, MessageCoding, MessageType, MessageContent)
select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1,
0, 0, 15, 0, 'XXX' + key + ',XXX' from inseted
insert into CA_HISTORY
select callnum ,key , getdate() from inseted
delete from CA where callnum in(select callnum from inserted)
end
as
beginINSERT INTO SGIP12_SUBMIT
(MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType,
FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid,
TP_udhi, MessageCoding, MessageType, MessageContent)
select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1,
0, 0, 15, 0, 'XXX' + key + ',XXX' from inseted
insert into CA_HISTORY
select callnum ,key , getdate() from inseted
delete from CA where callnum in(select callnum from inserted)
end
肯请 Dlut_LIuQ 给出无错语句,谢谢!
as
beginINSERT INTO SGIP12_SUBMIT
(MT_SendCount, SPNumber, ChargeNumber, UserNumber, ServiceType, FeeType,
FeeValue, GivenValue, AgentFlag, MorelatetoMTFlag, Priority, ReportFlag, TP_pid,
TP_udhi, MessageCoding, MessageType, MessageContent)
select 0, 'XXXX', callnum, callnum, 'HELP', 1, '000000', '0', 1, 2, 5, 1,
0, 0, 15, 0, 'XXX' +[key] + ',XXX' from inserted
insert into CA_HISTORY
select callnum ,[key] , getdate() from inserted
delete from CA where callnum in(select callnum from inserted)
end