比如这个触发器CREATE TRIGGER [TR_INSERTSGMRBB01] ON [dbo].[SGMRBB]
FOR INSERT
AS
DECLARE @RBB001 VARCHAR(2),
@RBB002 VARCHAR(14),
@RBB003 VARCHAR(3),
@RBB004 VARCHAR(20),
@DEA961 VARCHAR(60)
BEGIN TRANSACTION
SET NOCOUNT ON
SELECT @RBB001=RBB001,@RBB002=RBB002,@RBB003=RBB003,@RBB004=RBB004 FROM INSERTED
SELECT @DEA961=DEA961 FROM TPADEA WHERE DEA001=@RBB004
UPDATE SGMRBB SET RBB960=@DEA961 WHERE RBB001=@RBB001 AND RBB002=@RBB002 AND RBB003=@RBB003 AND RBB004=@RBB004
SET NOCOUNT OFF
COMMIT TRANSACTION
以及其他用到@的地方意义一样么?
FOR INSERT
AS
DECLARE @RBB001 VARCHAR(2),
@RBB002 VARCHAR(14),
@RBB003 VARCHAR(3),
@RBB004 VARCHAR(20),
@DEA961 VARCHAR(60)
BEGIN TRANSACTION
SET NOCOUNT ON
SELECT @RBB001=RBB001,@RBB002=RBB002,@RBB003=RBB003,@RBB004=RBB004 FROM INSERTED
SELECT @DEA961=DEA961 FROM TPADEA WHERE DEA001=@RBB004
UPDATE SGMRBB SET RBB960=@DEA961 WHERE RBB001=@RBB001 AND RBB002=@RBB002 AND RBB003=@RBB003 AND RBB004=@RBB004
SET NOCOUNT OFF
COMMIT TRANSACTION
以及其他用到@的地方意义一样么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货