ahmed salah

ahmed salah

  • NA
  • 530
  • 141k

Which data type store unit cost price and amount in sqlserv?

May 20 2017 4:48 PM
In sql server 2012 I design database for pharmaceutical company to store data of orders
 
Inside this database I have Table order inside it have three fields
 
Quantity
 
Unit Cost price
 
Amount( Quantity * Unit Cost price)
 
Quantity datatype is integer
 
What data type i can use for  Unit Cost price field and Amount field ?
 
Amount will be big because production Qunatity from  200000 to 1000000 box in order .
 
Unit cost price from 1 pound to 200 pound .
 
so that Which data type store unit cost price and amount in sqlserver 2012? 
 

Answers (3)