Advice in using ms sql data types as in INT and BIGINT, also as in NUMERIC DECIMAL MONEY
We understand that INT and BIGINT are for whole numbers and NUMERIC/DECIMAL/MONEY are for numeric values with decimals. For our tables when needing to store whole numbers, we always use INT and when we need to store numeric values with decimal, we always use NUMERIC. Please advice on:
Thank you.
- When creating a table with column whole numbers, which is most recommended?
- Same with decimal values, in NUMERIC/DECIMAL/MONEY which is most recommended when creating a column decimal places needed?
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.