Message
From
11/09/2006 13:30:35
Marc Levesque
La Prairie
,
Quebec
,
Canada
To
11/09/2006 13:27:35
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:
01152809
Views:
31
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
Previous
Next
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only