Given a table ITEM as below :
CREATE TABLE ITEM ( ItemNo int not null, category varchar(20) not null, Quantity int not null, Price decimal(10,2) not null, Total decimal(10,2) not null, CONSTRAINT pk_item primary key (ItemNo) );
I need to write a row-level trigger called update_item that will fire whenever Quantity and/or Price is inserted/updated. When this happens, the Total column will be set by the trigger as the product of Quantity and Price.
Any help will be appreciated.