sql server触发器引用最后一行

发布于 2024-10-05 05:03:58 字数 338 浏览 0 评论 0原文

我想在 SQL Server 中编写一个触发器，以便在向 table1 中插入一行时，向 table2 中插入 2 行。我想使用 table1 中的列值。

所以我的触发器看起来像这样

create trigger triggername on table1
as
begin
insert into
insert into
end

How do I get the value of any columns from the Last插入的行（触发触发器的行插入）。即相当于oracle中的“引用行”

原文

I want to write a trigger in SQL Server to insert 2 rows into table2 when a row is inserted into table1. I want to use a column value from table1.

So my trigger looks like this

create trigger triggername on table1
as
begin
insert into
insert into
end

How do I get the value of any column from the last inserted row (the row insertion which fires the trigger). I.e. the equivalent of 'referencing row' in oracle

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

锦爱 2024-10-12 05:03:59

SQL Server 中的触发器按语句而不是按行触发。您可以使用两个伪表 inserted 和 deleted（对于 insert 触发器，唯一感兴趣的是 inserted代码>)

CREATE TRIGGER YourTrigger ON Table1
FOR INSERT
AS
INSERT INTO Table2 
SELECT * from inserted /*This will contain multiple rows if it is a multi-row insert*/

Triggers in SQL Server fire per statement not per row. There are two pseudo tables inserted and deleted that you can use (for an insert trigger the only one of interest is inserted)

CREATE TRIGGER YourTrigger ON Table1
FOR INSERT
AS
INSERT INTO Table2 
SELECT * from inserted /*This will contain multiple rows if it is a multi-row insert*/

回复收藏 0 原文