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:30:35

Marc Levesque
La Prairie, Québec, Canada

À

11/09/2006 13:27:35

Naomi Nosonovsky
Wisconsin, États-Unis

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:

01152809

Vues:

30

If I try this...

INSERT INTO MyTable_tmp SELECT * FROM Inserted

I got the following error... (on the check syntax)
Error 311: Cannot use text, ntext or image columns in the 'Inserted' and 'Deleted' tables.

Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca

Click here to load this message in the networking platform