CREATE TRIGGER [TRIGSENDMT] ON dbo.BOX_MT
FOR INSERT
AS
begin
declare @Areaid int ,@Sender varchar(20),@mobile varchar (11),@number int
Select @Areaid= areaid,@Sender=Sender,@mobile=mobile from inserted
begin
set @number = cast(Right(@mobile,1) as int )
if @number%2 = 0
insert into box_mt_0(areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime)
(select areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime
from inserted)
else
insert into box_mt_1(areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime)
(select areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime
from inserted)
end
end谁帮我解释一下?
FOR INSERT
AS
begin
declare @Areaid int ,@Sender varchar(20),@mobile varchar (11),@number int
Select @Areaid= areaid,@Sender=Sender,@mobile=mobile from inserted
begin
set @number = cast(Right(@mobile,1) as int )
if @number%2 = 0
insert into box_mt_0(areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime)
(select areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime
from inserted)
else
insert into box_mt_1(areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime)
(select areaid,objtype,mobile,message,sender,feemobile,servicetype,
feetype,feevalue,givenvalue,motomtflag,reportflag,msgtype,createtime
from inserted)
end
end谁帮我解释一下?
如果 number能被2整除,则插入一些数据到box_mt_0 表
否则 则插入一些数据到box_mt_1 表