inserted in dynamic query

microsoft.public.sqlserver.programming

28 Dec 2005 8:02 PM

helpful sql

Hi,
Is it possible to use inserted or deleted tables in a dynamic query in a
trigger?

Thanks.

28 Dec 2005 8:35 PM

Ryan Powers

No, you can only reference the inserted and deleted tables within the context
of the trigger.

What exactly are you trying to do? Perhaps there is a workaround.

Show quote

"helpful sql" wrote:

> Hi,
> Is it possible to use inserted or deleted tables in a dynamic query in a
> trigger?
>
> Thanks.
>
>
>