Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Which data type store unit cost price and amount in sqlserv?
ahmed salah
May 20 2017 4:48 PM
298
Reply
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?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Ineer Functionality of Sql for inser update and delete comma
How to make Trigger auto delete Column if stock Qty 0?