SQL INSERT触发器更新值 [英] SQL INSERT Trigger Updating Value

问题描述

嗨朋友们，



我试图在插入时更新表中的值..

我正在使用此触发器。 ..

 创建  TRIGGER  add_auth_code 
  ON  dbo.aspnet_Users 
 AFTER  INSERT  
  AS  
  BEGIN  
   -   添加SET NOCOUNT ON以防止额外的结果集 
   -   干扰SELECT语句。 
  SET   NOCOUNT   ON ; 
 authcode =   54464966464446; 
   -   在此处插入触发器语句 
 
  END  

我想将authcode设置为当前插入列,,,如何我可以更新吗,,,请有人帮助我....

解决方案

您好请参考以下示例，它可能对您有所帮助，您必须使用关键列与Inserted Table连接的表。所以在这里你可以知道新插入记录的id或userid是什么。然后你可以对它进行更新。



示例代码4 U：



CREATE TRIGGER add_auth_code

ON dbo.aspnet_Users

插入后

AS

BEGIN



SET NOCOUNT ON;

更新p

SET authcode =54464966464446

来自dbo.Products AS p
INNER JOIN已插入AS i

ON p.ProductID = i.ProductID;





END



问候

穆斌

Hi friends,

I am trying to update a value in a table while inserting..
I am using this trigger...

CREATE TRIGGER add_auth_code
   ON  dbo.aspnet_Users
   AFTER INSERT
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    authcode = "54464966464446";
    -- Insert statements for trigger here

END

I want to set an authcode to the currently inserting column,,, How can I update it,,, Please somebody help me....

解决方案

Hi Please refer below example , it may help you, you have to use key columns of table in join with Inserted Table. so here you can know what is id or userid of newly inserted record. and then you can do update on it.

sample code 4 U:

CREATE TRIGGER add_auth_code
ON dbo.aspnet_Users
AFTER INSERT
AS
BEGIN

SET NOCOUNT ON;
UPDATE p
SET authcode = "54464966464446"
FROM dbo.Products AS p
INNER JOIN inserted AS i
ON p.ProductID = i.ProductID;


END

Regards
Mubin

这篇关于SQL INSERT触发器更新值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！