Create a trigger update only the price column


Discuss the below:

Trigger - Update item price in SQL server 2008

Create a trigger that will update only the price column for all 20 items in the table with its new price and this need to be executed all at one time.

The table name is: dbo.ITEM, column name is : price

1804_Table.PNG

Solution Preview :

Prepared by a verified Expert
Database Management System: Create a trigger update only the price column
Reference No:- TGS01938903

Now Priced at $25 (50% Discount)

Recommended (91%)

Rated (4.3/5)