blocks|key|3847489|text|您应该能够访问INSERTED表并检索ID或表的主键。类似于此示例的内容...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3847490|CREATE+TRIGGER+[dbo].[after_update]+ON+[dbo].[MYTABLE]
AFTER+UPDATE+AS+
BEGIN
++++DECLARE+@id+AS+INT
++++SELECT+@id+=+[IdColumnName]
++++FROM+INSERTED

++++UPDATE+MYTABLE+
++++SET+mytable.CHANGED_ON+=+GETDATE(),
++++CHANGED_BY=USER_NAME(USER_ID())
++++WHERE+[IdColumnName]+=+@id|code-block|syntax|javascript|3847491|在MSDN上有一个在使用触发器时可用的INSERTED和DELETED表的链接：http://msdn.microsoft.com/en-au/library/ms191300.aspx|3847492|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-au/library/ms191300.aspx^0|7|8|0|0|J|8|S|7|14|1H|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]]|E|$]]|$1|M|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

You should be able to access the <code>INSERTED</code> table and retrieve ID or table's primary key. Something similar to this example ...

<pre><code>CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE]
AFTER UPDATE AS 
BEGIN
 DECLARE @id AS INT
 SELECT @id = [IdColumnName]
 FROM INSERTED

 UPDATE MYTABLE 
 SET mytable.CHANGED_ON = GETDATE(),
 CHANGED_BY=USER_NAME(USER_ID())
 WHERE [IdColumnName] = @id
</code></pre>

Here's a link on MSDN on the <code>INSERTED</code> and <code>DELETED</code> tables available when using triggers: <a href="http://msdn.microsoft.com/en-au/library/ms191300.aspx" rel="nofollow">http://msdn.microsoft.com/en-au/library/ms191300.aspx</a>

blocks|key|1487388|text|首先，正如您已经看到的，触发器将更新表中的每条记录。由于行发生了变化，因此没有进行任何过滤。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487389|其次，假设批处理中只有一行发生了变化，这是不正确的，因为多行可能会发生变化。|1487390|正确做到这一点的方法是使用虚拟的插入和删除的表：http://msdn.microsoft.com/en-us/library/ms191300.aspx|offset|length|1487391|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms191300.aspx^0|0|0|O|1H|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

First off, your trigger as you already see is going to update every record in the table. There is no filtering done to accomplish jus the rows changed.

Secondly, you're assuming that only one row changes in the batch which is incorrect as multiple rows could change.

The way to do this properly is to use the virtual inserted and deleted tables: <a href="http://msdn.microsoft.com/en-us/library/ms191300.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms191300.aspx</a>

blocks|key|5265155|text|CREATE+TRIGGER+[dbo].[after_update]+ON+[dbo].[MYTABLE]
AFTER+UPDATE
AS
BEGIN
++++DECLARE+@ID+INT

++++SELECT+@ID+=+D.ID
++++FROM+inserted+D

++++UPDATE+MYTABLE
++++SET+mytable.CHANGED_ON+=+GETDATE()
++++++++,CHANGED_BY+=+USER_NAME(USER_ID())
++++WHERE+ID+=+@ID
END|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5265156|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE]
AFTER UPDATE
AS
BEGIN
 DECLARE @ID INT

 SELECT @ID = D.ID
 FROM inserted D

 UPDATE MYTABLE
 SET mytable.CHANGED_ON = GETDATE()
 ,CHANGED_BY = USER_NAME(USER_ID())
 WHERE ID = @ID
END
</code></pre>

blocks|key|3847581|text|以下是我在测试后的示例|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3847582|CREATE+TRIGGER+[dbo].UpdateTasadoresName+
ON+[dbo].Tasadores++
FOR++UPDATE
AS+
++++++UPDATE+Tasadores+
++++++SET+NombreCompleto+=+RTRIM(+Tasadores.Nombre+%2B+'+'+%2B+isnull(Tasadores.ApellidoPaterno,'')+%2B+'+'+%2B+isnull(Tasadores.ApellidoMaterno,'')++++)++
++++++FROM+Tasadores+
++++INNER+JOIN+INSERTED+i+ON+Tasadores.id+=+i.id|code-block|syntax|javascript|3847583|插入的特殊表格将包含来自更新记录的信息。|3847584|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here is my example after a test

<pre><code>CREATE TRIGGER [dbo].UpdateTasadoresName 
ON [dbo].Tasadores 
FOR UPDATE
AS 
 UPDATE Tasadores 
 SET NombreCompleto = RTRIM( Tasadores.Nombre + ' ' + isnull(Tasadores.ApellidoPaterno,'') + ' ' + isnull(Tasadores.ApellidoMaterno,'') ) 
 FROM Tasadores 
 INNER JOIN INSERTED i ON Tasadores.id = i.id
</code></pre>

The inserted special table will have the information from the updated record.

blocks|key|5265186|text|尝试此操作(更新，而不是在更新之后)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5265187|CREATE+TRIGGER+[dbo].[xxx_update]+ON+[dbo].[MYTABLE]
++++FOR+UPDATE
++++AS
++++BEGIN

++++++++UPDATE+MYTABLE
++++++++SET+mytable.CHANGED_ON+=+GETDATE()
++++++++++++,CHANGED_BY+=+USER_NAME(USER_ID())
++++++++FROM+inserted
++++++++WHERE+MYTABLE.ID+=+inserted.ID

++++END|code-block|syntax|javascript|5265188|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this (update, not after update) 

<pre><code>CREATE TRIGGER [dbo].[xxx_update] ON [dbo].[MYTABLE]
 FOR UPDATE
 AS
 BEGIN

 UPDATE MYTABLE
 SET mytable.CHANGED_ON = GETDATE()
 ,CHANGED_BY = USER_NAME(USER_ID())
 FROM inserted
 WHERE MYTABLE.ID = inserted.ID

 END
</code></pre>

blocks|key|1487426|text|要做到这一点非常简单，首先创建一个您想要保留日志的表的副本，例如，您有包含列SalesOrderId、FirstName、LastName、LastModified的表dbo.SalesOrder|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1487427|您的版本架构表应该是包含列SalesOrderVersionArhieveId、SalesOrderId、FirstName、LastName、LastModified的dbo.SalesOrderVersionArchieve|1487428|下面是如何在SalesOrder表上设置触发器|1487429|USE+[YOURDB]
GO
SET+ANSI_NULLS+ON
GO
SET+QUOTED_IDENTIFIER+ON
GO
--+=============================================
--+Author:++++++Karan+Dhanu
--+Create+date:+<Create+Date,,>
--+Description:+<Description,,>
--+=============================================
CREATE+TRIGGER+dbo.[CreateVersionArchiveRow]
+++ON++dbo.[SalesOrder]
++AFTER+Update
AS+
BEGIN

++++SET+NOCOUNT+ON;
INSERT+INTO+dbo.SalesOrderVersionArchive

+++SELECT+*
+++FROM+deleted;

END|code-block|syntax|javascript|1487430|现在，如果您在saleOrder表中进行了任何更改，它将显示VersionArchieve表中的更改|1487431|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

It is very simple to do that,
First create a copy of your table that your want keep the log for
For example you have Table dbo.SalesOrder with columns SalesOrderId, FirstName,LastName, LastModified

Your Version archieve table should be dbo.SalesOrderVersionArchieve with columns SalesOrderVersionArhieveId, SalesOrderId, FirstName,LastName, LastModified

Here is the how you will set up a trigger on SalesOrder table

<pre><code>USE [YOURDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Karan Dhanu
-- Create date: &lt;Create Date,,&gt;
-- Description: &lt;Description,,&gt;
-- =============================================
CREATE TRIGGER dbo.[CreateVersionArchiveRow]
 ON dbo.[SalesOrder]
 AFTER Update
AS 
BEGIN

 SET NOCOUNT ON;
INSERT INTO dbo.SalesOrderVersionArchive

 SELECT *
 FROM deleted;

END
</code></pre>

Now if you make any changes in saleOrder table it will show you the change in VersionArchieve table

blocks|key|1738029|text|尝试此解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1738030|+++++++DECLARE+@Id+INT
+++++++DECLARE+@field+VARCHAR(50)

+++++++SELECT+@Id=+INSERTED.CustomerId+++++++
+++++++FROM+INSERTED

+++++++IF+UPDATE(Name)
+++++++BEGIN
++++++++++++++SET+@field+=+'Updated+Name'
+++++++END

+++++++IF+UPDATE(Country)
+++++++BEGIN
++++++++++++++SET+@field+=+'Updated+Country'
+++++++END

+++++++INSERT+INTO+CustomerLogs
+++++++VALUES(@Id,+@field)

+++++++//+OR
+++++++--+If+you+wish+to+update+existing+table+records.
+++++++UPDATE+YOUR_TABLE+SET+[FIELD]=[VALUE]+WHERE+{CONDITION}|code-block|syntax|javascript|1738031|我没有在旧版本的sql+server上检查过这一点，但这可以在sql+server+2012上工作。|1738032|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

try this solution.

<pre><code> DECLARE @Id INT
 DECLARE @field VARCHAR(50)

 SELECT @Id= INSERTED.CustomerId 
 FROM INSERTED

 IF UPDATE(Name)
 BEGIN
 SET @field = 'Updated Name'
 END

 IF UPDATE(Country)
 BEGIN
 SET @field = 'Updated Country'
 END

 INSERT INTO CustomerLogs
 VALUES(@Id, @field)

 // OR
 -- If you wish to update existing table records.
 UPDATE YOUR_TABLE SET [FIELD]=[VALUE] WHERE {CONDITION}
</code></pre>

I didn't checked this with older version of sql server but this will work with sql server 2012.

blocks|key|1738046|text|尝试使用此脚本创建临时表TESTTEST，并观察触发器按以下顺序调用时的优先顺序:+1)+INSTEAD+OF、2)+FOR、3)+AFTER|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1738047|所有的逻辑都放在INSTEAD+of+trigger中，我有两个例子告诉你如何编写一些场景……|1738048|祝你好运。|1738049|CREATE+TABLE+TESTTEST
(
++++ID++INT,
++++Modified0+DATETIME,
++++Modified1+DATETIME
)
GO
CREATE+TRIGGER+[dbo].[tr_TESTTEST_0]+ON+[dbo].TESTTEST
INSTEAD+OF+INSERT,UPDATE,DELETE
AS
BEGIN
++++SELECT+'INSTEAD+OF'
++++SELECT+'TT0.0'
++++SELECT+*+FROM+TESTTEST

++++SELECT+*,+'I'+Mode
++++INTO+#work
++++FROM+INSERTED

++++UPDATE+#work+SET+Mode='U'+WHERE+ID+IN+(SELECT+ID+FROM+DELETED)
++++INSERT+INTO+#work+(ID,+Modified0,+Modified1,+Mode)
++++SELECT+ID,+Modified0,+Modified1,+'D'
++++FROM+DELETED+WHERE+ID+NOT+IN+(SELECT+ID+FROM+INSERTED)

++++--Check+Security+or+any+other+logic+to+add+and+remove+from+#work+before+processing
++++DELETE+FROM+#work+WHERE+ID=9+--+because+you+don't+want+anyone+to+edit+this+id?!?!
++++DELETE+FROM+#work+WHERE+Mode='D'+--+because+you+don't+want+anyone+to+delete+any+records

++++SELECT+'EV'
++++SELECT+*+FROM+#work

++++IF(EXISTS(SELECT+TOP+1+*+FROM+#work+WHERE+Mode='I'))
++++BEGIN
++++++++SELECT+'I0.0'
++++++++INSERT+INTO+dbo.TESTTEST+(ID,+Modified0,+Modified1)
++++++++SELECT+ID,+Modified0,+Modified1
++++++++FROM+#work
++++++++WHERE+Mode='I'
++++++++SELECT+'Cool+stuff+would+happen+here+if+you+had+FOR+INSERT+or+AFTER+INSERT+triggers.'
++++++++SELECT+'I0.1'
++++END

++++IF(EXISTS(SELECT+TOP+1+*+FROM+#work+WHERE+Mode='D'))
++++BEGIN
++++++++SELECT+'D0.0'
++++++++DELETE+FROM+TESTTEST+WHERE+ID+IN+(SELECT+ID+FROM+#work+WHERE+Mode='D')
++++++++SELECT+'Cool+stuff+would+happen+here+if+you+had+FOR+DELETE+or+AFTER+DELETE+triggers.'
++++++++SELECT+'D0.1'
++++END

++++IF(EXISTS(SELECT+TOP+1+*+FROM+#work+WHERE+Mode='U'))
++++BEGIN
++++++++SELECT+'U0.0'
++++++++UPDATE+t+SET+t.Modified0=e.Modified0,+t.Modified1=e.Modified1
++++++++FROM+dbo.TESTTEST+t
++++++++INNER+JOIN+#work+e+ON+e.ID+=+t.ID
++++++++WHERE+e.Mode='U'
++++++++SELECT+'U0.1'
++++END
++++DROP+TABLE+#work

++++SELECT+'TT0.1'
++++SELECT+*+FROM+TESTTEST
END
GO
CREATE+TRIGGER+[dbo].[tr_TESTTEST_1]+ON+[dbo].TESTTEST
FOR+UPDATE
AS
BEGIN
++++SELECT+'FOR+UPDATE'

++++SELECT+'TT1.0'
++++SELECT+*+FROM+TESTTEST

++++SELECT+'I1'
++++SELECT+*+FROM+INSERTED

++++SELECT+'D1'
++++SELECT+*+FROM+DELETED

++++SELECT+'TT1.1'
++++SELECT+*+FROM+TESTTEST
END
GO
CREATE+TRIGGER+[dbo].[tr_TESTTEST_2]+ON+[dbo].TESTTEST
AFTER+UPDATE
AS
BEGIN
++++SELECT+'AFTER+UPDATE'

++++SELECT+'TT2.0'
++++SELECT+*+FROM+TESTTEST

++++SELECT+'I2'
++++SELECT+*+FROM+INSERTED

++++SELECT+'D2'
++++SELECT+*+FROM+DELETED

++++SELECT+'TT2.1'
++++SELECT+*+FROM+TESTTEST
END
GO

SELECT+'Start'
INSERT+INTO+TESTTEST+(ID,+Modified0)+VALUES+(9,+GETDATE())--+not+going+to+insert
SELECT+'RESTART'
INSERT+INTO+TESTTEST+(ID,+Modified0)+VALUES+(10,+GETDATE())--going+to+insert
SELECT+'RESTART'
UPDATE+TESTTEST+SET+Modified1=GETDATE()+WHERE+ID=10--+gointo+to+update
SELECT+'RESTART'
DELETE+FROM+TESTTEST+WHERE+ID=10--+not+going+to+DELETE
SELECT+'FINISHED'

SELECT+*+FROM+TESTTEST
DROP+TABLE+TESTTEST|code-block|syntax|javascript|1738050|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Try this script to create a temporary table TESTTEST and watch the order of precedence as the triggers are called in this order: 1) INSTEAD OF, 2) FOR, 3) AFTER

All of the logic is placed in INSTEAD OF trigger and I have 2 examples of how you might code some scenarios...

Good luck...

<pre><code>CREATE TABLE TESTTEST
(
 ID INT,
 Modified0 DATETIME,
 Modified1 DATETIME
)
GO
CREATE TRIGGER [dbo].[tr_TESTTEST_0] ON [dbo].TESTTEST
INSTEAD OF INSERT,UPDATE,DELETE
AS
BEGIN
 SELECT 'INSTEAD OF'
 SELECT 'TT0.0'
 SELECT * FROM TESTTEST

 SELECT *, 'I' Mode
 INTO #work
 FROM INSERTED

 UPDATE #work SET Mode='U' WHERE ID IN (SELECT ID FROM DELETED)
 INSERT INTO #work (ID, Modified0, Modified1, Mode)
 SELECT ID, Modified0, Modified1, 'D'
 FROM DELETED WHERE ID NOT IN (SELECT ID FROM INSERTED)

 --Check Security or any other logic to add and remove from #work before processing
 DELETE FROM #work WHERE ID=9 -- because you don't want anyone to edit this id?!?!
 DELETE FROM #work WHERE Mode='D' -- because you don't want anyone to delete any records

 SELECT 'EV'
 SELECT * FROM #work

 IF(EXISTS(SELECT TOP 1 * FROM #work WHERE Mode='I'))
 BEGIN
 SELECT 'I0.0'
 INSERT INTO dbo.TESTTEST (ID, Modified0, Modified1)
 SELECT ID, Modified0, Modified1
 FROM #work
 WHERE Mode='I'
 SELECT 'Cool stuff would happen here if you had FOR INSERT or AFTER INSERT triggers.'
 SELECT 'I0.1'
 END

 IF(EXISTS(SELECT TOP 1 * FROM #work WHERE Mode='D'))
 BEGIN
 SELECT 'D0.0'
 DELETE FROM TESTTEST WHERE ID IN (SELECT ID FROM #work WHERE Mode='D')
 SELECT 'Cool stuff would happen here if you had FOR DELETE or AFTER DELETE triggers.'
 SELECT 'D0.1'
 END

 IF(EXISTS(SELECT TOP 1 * FROM #work WHERE Mode='U'))
 BEGIN
 SELECT 'U0.0'
 UPDATE t SET t.Modified0=e.Modified0, t.Modified1=e.Modified1
 FROM dbo.TESTTEST t
 INNER JOIN #work e ON e.ID = t.ID
 WHERE e.Mode='U'
 SELECT 'U0.1'
 END
 DROP TABLE #work

 SELECT 'TT0.1'
 SELECT * FROM TESTTEST
END
GO
CREATE TRIGGER [dbo].[tr_TESTTEST_1] ON [dbo].TESTTEST
FOR UPDATE
AS
BEGIN
 SELECT 'FOR UPDATE'

 SELECT 'TT1.0'
 SELECT * FROM TESTTEST

 SELECT 'I1'
 SELECT * FROM INSERTED

 SELECT 'D1'
 SELECT * FROM DELETED

 SELECT 'TT1.1'
 SELECT * FROM TESTTEST
END
GO
CREATE TRIGGER [dbo].[tr_TESTTEST_2] ON [dbo].TESTTEST
AFTER UPDATE
AS
BEGIN
 SELECT 'AFTER UPDATE'

 SELECT 'TT2.0'
 SELECT * FROM TESTTEST

 SELECT 'I2'
 SELECT * FROM INSERTED

 SELECT 'D2'
 SELECT * FROM DELETED

 SELECT 'TT2.1'
 SELECT * FROM TESTTEST
END
GO

SELECT 'Start'
INSERT INTO TESTTEST (ID, Modified0) VALUES (9, GETDATE())-- not going to insert
SELECT 'RESTART'
INSERT INTO TESTTEST (ID, Modified0) VALUES (10, GETDATE())--going to insert
SELECT 'RESTART'
UPDATE TESTTEST SET Modified1=GETDATE() WHERE ID=10-- gointo to update
SELECT 'RESTART'
DELETE FROM TESTTEST WHERE ID=10-- not going to DELETE
SELECT 'FINISHED'

SELECT * FROM TESTTEST
DROP TABLE TESTTEST
</code></pre>

blocks|key|3847637|text|您可以调用INSERTED，SQL+Server使用这些表来捕获事件发生前后修改的行的数据。我假设在您的表中键的名称是Id|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3847638|我认为下面的代码可以帮助你|3847639|CREATE+TRIGGER+[dbo].[after_update]
ON+[dbo].[MYTABLE]
+++AFTER+UPDATE
AS
BEGIN
++++UPDATE+dbo.[MYTABLE]
++++SET++++dbo.[MYTABLE].CHANGED_ON+=+GETDATE(),
+++++++++++dbo.[MYTABLE].CHANGED_BY+=+USER_NAME(USER_ID())
++++FROM+++INSERTED
++++WHERE++INSERTED.Id+=+dbo.[MYTABLE].[Id]
END|code-block|syntax|javascript|3847640|entityMap^0|5|8|1N|2|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|U|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

you can call <code>INSERTED</code>, SQL Server uses these tables to capture the data of the modified row before and after the event occurs.I assume in your table the name of the key is <code>Id</code>

I think the following code can help you

<pre><code>CREATE TRIGGER [dbo].[after_update]
ON [dbo].[MYTABLE]
 AFTER UPDATE
AS
BEGIN
 UPDATE dbo.[MYTABLE]
 SET dbo.[MYTABLE].CHANGED_ON = GETDATE(),
 dbo.[MYTABLE].CHANGED_BY = USER_NAME(USER_ID())
 FROM INSERTED
 WHERE INSERTED.Id = dbo.[MYTABLE].[Id]
END
</code></pre>

I have a problem with this trigger. I would like it to update the requested information
only to the row in question (the one I just updated) and not the entire table. 

<pre><code>CREATE TRIGGER [dbo].[after_update] 
 ON [dbo].[MYTABLE]
 AFTER UPDATE
 AS 
 BEGIN
 UPDATE MYTABLE 
 SET mytable.CHANGED_ON = GETDATE(),
 CHANGED_BY=USER_NAME(USER_ID())
</code></pre>

How do I tell the trigger that this applies only to the row in question?

SQL Server after update trigger

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我对这个扳机有点问题。我希望它只将请求的信息更新到有问题的行(我刚刚更新的那行)，而不是整个表。CREATE TRIGGER [dbo].[after_update]     ON [dbo].[MYTABLE]    AFTER UPDATE    AS     BEGIN          UPDATE MYTAB...

问SQL Server更新后触发器
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server更新后触发器EN