Define table for product

Question

Hello Sir.. I am working in asp.net technology with sqlserver 2008. I want to design database for quantity and price for any product . Please define how can we calculate price when we select one or more quantity of any product?

Pravinkumar Birajdar · Answer

use following query select ProductIDProductNameQtyPriceQty*Price As Amount from MST_Products

Jignesh Trivedi · Answer

hi Sorry I am not getting you question. you want auto calculated filed? --> we can use computed column in sql server Is there any formula to calculate total price?