April 29, 2002 at 9:26 am
I am sure this is an easy one all, but I am new to SQL Server.
How do you get the value of a particuilar column of the currently updated row.
Thanks in advance.
J
April 29, 2002 at 11:13 am
The logical inserted and deleted tables let you see the before/after image. Remember that these tables may hold 0 or more rows, the trigger fires once per transaction, not once per row.
Andy
April 30, 2002 at 5:25 am
quote:
How do you get the value of a particuilar column of the currently updated row.
If to verify then Andy is correct with triggers as the best place. But if you want the value after the row has been updated then you have to requery the row and that depends on how you did the update if in code, as to what steps are needed. If SQL queries then just do a SELECT for the row to get the value output again.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply