Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why temp table Inserted is not visible outside trigger?
Message
From
06/09/2009 23:04:10
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Why temp table Inserted is not visible outside trigger?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01152798
Message ID:
01422914
Views:
52
>>It seems that I cannot access Inserted outside trigger?
>>Is it right? If so, is exist another way?
>
>Yes. Inserted/Deleted tables are visible only in triggers. What you are trying to do?

In SQL Server 2005 and up you can access them using new OUTPUT clause.

See

http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform