Why temp table Inserted is not visible outside trigger? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Why temp table Inserted is not visible outside trigger?

Message

De

11/09/2006 13:27:35

Naomi Nosonovsky
Wisconsin, États-Unis

À

11/09/2006 13:26:23

Marc Levesque
La Prairie, Québec, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: Why temp table Inserted is not visible outside trigger?

Versions des environnements

SQL Server:

SQL Server 2000

Divers

Thread ID:

01152798

Message ID:

01152805

Vues:

26

>I want to copy the last record inserted into another table, but I don't want to do a select from my table because it is too huge.

Can you do it in a trigger's code?

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform