hojohappy
asked on
SQL Server Data Type to use for Whole Number
WHat is the best data type to use for a table column to contain whole numbers? These are amounts but do not need a decimal so I assuming Integer would be best type to use. They will be need to be formatted on reports with ","
For example; 45000 or 67000
For example; 45000 or 67000
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Recommend you store this in the database as one of the above int types, and let whatever reporting tool you're using handle the thousands-separating commas.