想要个简单点的触发器。。
下面的是我自己做的,可是要是有40个no字段这样写起来太烦琐了,有没有什么简便的方法。。
CREATE TRIGGER [TR_RainHour_YS] ON [dbo].[RainHour]
FOR INSERT
AS
DECLARE @YMDHM smalldatetime
DECLARE @VAL numeric(6, 2)begin
SET @YMDHM = (SELECT endtime FROM Inserted)
SET @VAL = (SELECT no01 FROM Inserted)
insert into ST_RTRUNDETAIL_MAIN (STCD,TM,DA,STIME,TP,STP,FLAG,OGID) values('no01',@YMDHM,@VAL,getdate(),1,11,0,400410)
SET @VAL = (SELECT no02 FROM Inserted)
insert into ST_RTRUNDETAIL_MAIN (STCD,TM,DA,STIME,TP,STP,FLAG,OGID) values('no02',@YMDHM,@VAL,getdate(),1,11,0,400410)
end
下面的是我自己做的,可是要是有40个no字段这样写起来太烦琐了,有没有什么简便的方法。。
CREATE TRIGGER [TR_RainHour_YS] ON [dbo].[RainHour]
FOR INSERT
AS
DECLARE @YMDHM smalldatetime
DECLARE @VAL numeric(6, 2)begin
SET @YMDHM = (SELECT endtime FROM Inserted)
SET @VAL = (SELECT no01 FROM Inserted)
insert into ST_RTRUNDETAIL_MAIN (STCD,TM,DA,STIME,TP,STP,FLAG,OGID) values('no01',@YMDHM,@VAL,getdate(),1,11,0,400410)
SET @VAL = (SELECT no02 FROM Inserted)
insert into ST_RTRUNDETAIL_MAIN (STCD,TM,DA,STIME,TP,STP,FLAG,OGID) values('no02',@YMDHM,@VAL,getdate(),1,11,0,400410)
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货