TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed salah
NA
530
148.7k
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?
Reply
Answers (
3
)
Ineer Functionality of Sql for inser update and delete comma
How to make Trigger auto delete Column if stock Qty 0?