34,575
社区成员
发帖
与我相关
我的任务
分享
create TRIGGER [dbo].[add_MOCTG]
ON [dbo].[MOCTG]
FOR INSERT
AS
--MOCTG增加了一条数据,获取主表MOCTF表的内容,并且获取主表仓库的内容
BEGIN
update a set TG010=c.UDF06
from MOCTG a
inner join inserted b on a.TG001=b.TG001 and a.TG002=b.TG002
inner join MOCTF c on a.TG001=c.TF001 and a.TG002=TF002
where len(UDF06)>0
END
SELECT * INTO #tmp FROM INSERTED
ALTER TABLE #tmp ADD rid INT IDENTITY(1,1)
DECLARE @i INT,@imax INT
SELECT @i=1,@imax=MAX(rid) FROM #tmp;
WHILE @i<=@imax
BEGIN
SELECT * FROM #tmp WHERE rid=@i;
--todo
SET @i=@i+1
END
DROP TABLE #tmp;