>Hi All,
>I am trying to figure out if the field value was changed by one user during another user data manipulation.
>Something similar to OLDVAL() and CURVAL() functions, which I can use in the UPDATE trigger to see if the critical data, like quantities was changed.
>
>Thank you in advance
>Yelena
Yelena,
There is no similar concept in SQL Server. You may want to implement your own by using Audit table or using Rowversion and do comparison. This is actually how Entity Framework works and detects conflicts.
If it's not broken, fix it until it is.
My Blog