Update a column when insert/update the row

Hi Eshani,

Why do you think you can't use a computed column in this sceanrio. If the logic to calculate the due date is based only on the invoice date and payment frequency, which are other columnd in the same row, then this is a classic scenario for a computed column. You can put the same logic that you would put in a trigger - in a computed column. It would be more efficient and easier to maintain.

--------------------------------------------

Guy Glantser

SQL Server Consultant & Instructor

Madeira - SQL Server Services

http://ift.tt/Tl7DRW