Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why temp table Inserted is not visible outside trigger?
Message
 
 
À
11/09/2006 13:22:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01152798
Message ID:
01422914
Vues:
51
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform