I am currently migrating MS access databases to MS SQL. I have a field with a decimal data type in MS Access with a field length 16 and 2 decimal place values (values after the decimal point). How is this converted in MS SQL if Decimal data type has a maximum field length of only 9? I appreciate the help....pls anybody reply...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Decimal Data type in Access, what about in SQL
- Thread starter EdenD
- Start date
rajeevnandanmishra
Programmer
Hi there,
You can give prec=16 and scale=2
You can give prec=16 and scale=2
tlbroadbent
MIS
In SQL 7 and 2000 you can have precision up to 38 digits. Be careful not to confuse the precision (number of digits) with amount of storage (in bytes) required for a level of precision. SQL BOL contains more info including this table.
[tt]
Precision Bytes
1 - 9 5
10-19 9
20-28 13
29-38 17[/tt] Terry
Neither success nor failure is ever final. -Roger Babson
[tt]
Precision Bytes
1 - 9 5
10-19 9
20-28 13
29-38 17[/tt] Terry
Neither success nor failure is ever final. -Roger Babson
- Status
Similar threads
- Locked
- Question
