set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [TRi_yhhb] ON [dbo].[mq_yhhb]
FOR INSERT
AS
DECLARE
@yhbh varchar(100),
@ybh varchar(20),
@xbh varchar(20),
@yblx int,
@xblx int,
@ybzs numeric(9,0),
@xbzs numeric(9,0),
@czy varchar(20),
@czsj datetime,
@bz varchar(100)
set @yhbh=(select c_yhbh from inserted)
set @ybh=(select c_ybh from inserted)
set @xbh=(select c_xbh from inserted)
set @yblx=(select i_yblx from inserted)
set @xblx=(select i_xblx from inserted)
set @ybzs=(select f_ybzs from inserted)
set @xbzs=(select f_xbzs from inserted)
set @czy=(select c_czy from inserted)
set @czsj=(select d_hbsj from inserted)
set @bz='原表号:'||@ybh||'新表号'||@xbh||'原表类型'||@yblx||'新表类型'||@xblx||'原表指针'||@ybzs||'新表指针'||@xbzs
update mq_yhxx set c_bh=@xbh,f_bds=@xbzs,r_yqbxh=@xblx where c_yhbh=@yhbh
insert into mq_tsyw(c_czy,d_czsj,c_czlx,c_yhbh,c_bz)values(@czy,@czsj,'用户换表',@yhbh,@bz)那个set @bz= 后面的内容应该怎么写??帮忙下,在线等!!
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [TRi_yhhb] ON [dbo].[mq_yhhb]
FOR INSERT
AS
DECLARE
@yhbh varchar(100),
@ybh varchar(20),
@xbh varchar(20),
@yblx int,
@xblx int,
@ybzs numeric(9,0),
@xbzs numeric(9,0),
@czy varchar(20),
@czsj datetime,
@bz varchar(100)
set @yhbh=(select c_yhbh from inserted)
set @ybh=(select c_ybh from inserted)
set @xbh=(select c_xbh from inserted)
set @yblx=(select i_yblx from inserted)
set @xblx=(select i_xblx from inserted)
set @ybzs=(select f_ybzs from inserted)
set @xbzs=(select f_xbzs from inserted)
set @czy=(select c_czy from inserted)
set @czsj=(select d_hbsj from inserted)
set @bz='原表号:'||@ybh||'新表号'||@xbh||'原表类型'||@yblx||'新表类型'||@xblx||'原表指针'||@ybzs||'新表指针'||@xbzs
update mq_yhxx set c_bh=@xbh,f_bds=@xbzs,r_yqbxh=@xblx where c_yhbh=@yhbh
insert into mq_tsyw(c_czy,d_czsj,c_czlx,c_yhbh,c_bz)values(@czy,@czsj,'用户换表',@yhbh,@bz)那个set @bz= 后面的内容应该怎么写??帮忙下,在线等!!
FOR INSERT
AS
UPDATE A SET
A.C_BH=B.C_XBH,A.F_BDS=B.F_XBZS,A.R_YQBXH=B.I_XBLX
FROM MQ_YHXX A
JOIN INSERTED B
ON A.C_YHBH=B.C_YHBH
INSERT INTO MQ_TSYW(C_CZY,D_CZSJ,C_CZLX,C_YHBH,C_BZ)
SELECT C_CZY,D_HBSJ,'用户换表',C_YHBH,
'原表号:'+@YBH||' 新表号:'+@XBH+' 原表类型:'+LTRIM(@YBLX)
+' 新表类型:'+LTRIM(@XBLX)+' 原表指针:'+LTRIM(@YBZS)+' 新表指针:'+LTRIM(@XBZS)
FROM INSERTED
GO改为这样。
FOR INSERT
AS
UPDATE A SET
A.C_BH=B.C_XBH,A.F_BDS=B.F_XBZS,A.R_YQBXH=B.I_XBLX
FROM MQ_YHXX A
JOIN INSERTED B
ON A.C_YHBH=B.C_YHBH
INSERT INTO MQ_TSYW(C_CZY,D_CZSJ,C_CZLX,C_YHBH,C_BZ)
SELECT C_CZY,D_HBSJ,'用户换表',C_YHBH,
'原表号:'+C_YBH+' 新表号:'+C_YBH+' 原表类型:'+LTRIM(I_YBLX)
+' 新表类型:'+LTRIM(I_XBLX)+' 原表指针:'+LTRIM(F_YBZS)+' 新表指针:'+LTRIM(F_XBZS)
FROM INSERTED
GO改一下,最终这样。