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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Why temp table Inserted is not visible outside trigger?

Message

From

11/09/2006 13:27:35

Naomi Nosonovsky
Wisconsin, United States

To

11/09/2006 13:26:23

Marc Levesque
La Prairie, Quebec, Canada

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:

01152805

Views:

24

>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