SQL use trigger during insert for calculating value in one table
I have two tables, first with parts, second with orders. In orders i store IDPart and quantity of this part. I would like achieve that when inserting the IDPart and Quantity values into the Orders, the trigger automatically fires up to calculate the price. Did someone can help to figure it out? Sample: CREATE TABLE […]