开发者

DDL statements against deleted inserted in DML trigger

开发者 https://www.devze.com 2022-12-14 09:17 出处:网络
I am trying to find impact of doing DDL statement against deleted and inserted logical tables inside table trigger. I have:

I am trying to find impact of doing DDL statement against deleted and inserted logical tables inside table trigger. I have:

CREATE TRIGGER [Trigger52]
ON [dbo].[Table1]
FOR DELETE, INSERT, UPDATE 
AS 
BEG开发者_如何转开发IN
     create table inserted (c1 int)
     select * from inserted                        
END

When it is triggered, I expected to get an error. Instead, it seems to ignore create table statement entirely and select rows that have been inserted.

Is there a documentation describing this behavior or explanation?


Inside triggers there are always two pseudo-tables existing: inserted and deleted. See Using the inserted and deleted Tables:

SQL Server automatically creates and manages these tables. You can use these temporary, memory-resident tables to test the effects of certain data modifications and to set conditions for DML trigger actions. You cannot directly modify the data in the tables or perform data definition language (DDL) operations on the tables.

0

精彩评论

暂无评论...
验证码 换一张
取 消