isnull(starting,''),isnull(substring(convert(varchar(30),time_start,2
0),12,5),'1900-1-1'),
isnull(substring(convert(varchar(30),time_end,20),12,5),'1900-1-
1'),isnull(storehouse,''),
isnull(process,''),isnull(kind,''),isnull(material,''),isnull(place,'
'),cast(isnull(weight,'') as decimal(30,2)),1,time_end from inserted
ALTER TRIGGER [dbo].[djh_gfl3_2trig] ON [dbo].[Rpt_OutRtn_Sbarn]
FOR INSERT
AS
insert into djh_gfl3_2
(S1F01y,S1F01y,S1F01b,S1F01z,S1Y02y,S1Y02b,S1Y02z,S1Y03y,S1Y03b,S1Y03
z,S1Y04y,S1Y04b,S1Y04z,S1Y05y,
S1Y05b,S1Y05z,S1Y06y,S1Y06b,S1Y06z,S1Y07y,S1Y07b,S1Y07z,S1Y08y,S1Y08b
,S1Y08z,S1R09y,S1R09b,S1R09z,S1R10y,S1R10b,
S1R10z,S1R11y,S1R11b,S1R11z,SCM01y,SCM01b,SCM01z,SCM02y,SCM02b,SCM02z
,SCM03y,SCM03b,SCM03z,SCM04y,SCM04b,SCM04z,
systime) select
S1F01y,S1F01y,S1F01b,S1F01z,S1Y02y,S1Y02b,S1Y02z,S1Y03y,S1Y03b,S1Y03z
,S1Y04y,S1Y04b,S1Y04z,S1Y05y,
S1Y05b,S1Y05z,S1Y06y,S1Y06b,S1Y06z,S1Y07y,S1Y07b,S1Y07z,S1Y08y,S1Y08b
,S1Y08z,S1R09y,S1R09b,S1R09z,S1R10y,S1R10b,
S1R10z,S1R11y,S1R11b,S1R11z,SCM01y,SCM01b,SCM01z,SCM02y,SCM02b,SCM02z
,SCM03y,SCM03b,SCM03z,SCM04y,SCM04b,SCM04z,
systime from inserted
ALTER TRIGGER [dbo].[djh_gfl4_1trig] ON [dbo].[Rpt_OutRtn_Record]
FOR INSERT
AS
insert into djh_gfl4_1 select record,team,systime from inserted
ALTER TRIGGER [dbo].[djh_gfl4_2trig] ON [dbo].[Rpt_OutRtn_Process]
FOR INSERT
AS
insert into djh_gfl4_2 select
process,substring(convert(varchar(30),time_start,20),12,5),substring(
convert(varchar(30),time_end,20),12,5),
isnull(reason,''),time_start from inserted
评论0
最新资源