General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Thank you
>>Hi All,
>>I have "nStndCost" field, that holds a Standard Cost of the product, and dStndCost (smalldatetime) field in my "Inventory" table.I want to make sure that if the value of the "nStndCost" field is changed by anyone, the dStndCost field (smalldatetime) will change its value to the current date time.
>>I cannot update field values it in the AFTER UPDATE trigger on the "Inventory" table. Where can I trigger the change?
>
>The AFTER UPDATE trigger is only place where you can do that.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only