590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER [dbo].[tigger_transdata_to_lvkeserver]
ON [dbo].[Batterydata]
AFTER insert
AS
DECLARE @code char(30)
DECLARE @khdh char(30)
DECLARE @beforeweight char(30)
DECLARE @beforedate char(30)
--DECLARE @sid char(40)
BEGIN
SET @code = (select code from inserted)
SET @beforeweight = (select beforeweight from inserted)
SET @beforedate = (select beforedate from inserted)
SET @khdh = (select SUBSTRING(code,1,3) from inserted)
--SET @sid = ()
set xact_abort ON
if(@khdh = 'VDF')
BEGIN
insert lvke_Server.mes_lvke.dbo.mes_dcm_zy (SID,SITE,DC_NO,CONT_NO,END_DATE_TIME,O_1,O_4) values (newid(),'S021','ASUS','SFC',@beforedate,@code,@beforeweight)
-- Insert statements for trigger here
END
END