Insert current values of updated table   

SQL Server 2005.

I want to implement an update trigger that will write the current
(new) values to a new table.  How do I get the current values for this
updated row?

thanks,

steve

date: Thu, 7 Aug 2008 13:08:36 -0700 (PDT)   author:   sfp

Re: Insert current values of updated table   

On Aug 8, 1:08 am, sfp  wrote:
> SQL Server 2005.
>
> I want to implement an update trigger that will write the current
> (new) values to a new table.  How do I get the current values for this
> updated row?
>
> thanks,
>
> steve

Triggers has two logical tables inserted and deleted. you can use
inserted table to get new updated tables

Amish Shah
http://shahamishm.tripod.com

date: Thu, 7 Aug 2008 23:31:09 -0700 (PDT)   author:   amish