>>>>>Hi,
>>>>>I would like to create a SQL Server command that would set a column to a value and at the same time set the value before the change.
>>>>>
>>
>>>>Look into OUTPUT clause for UPDATE command in order to set variables of before and after values (Deleted and Inserted tables).
>>>
>>>Did you see what Hugo suggested? And thank you for your suggestions.
>>
>>I saw it, but it's not a good suggestion. OUTPUT clause is the way to go.
>
>Why putting both the UPDATE and SET in the same expression is not a good suggestion?
Because this is not documented as far as I know and you don't want to use undocumented features.
If it's not broken, fix it until it is.
My Blog