Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vbx
Starting Member
38 Posts |
 Posted - 2008-04-16 : 00:03:38
|
I have just loaded my db table from an excel file using the import wizard. Prior to the import, I set my data types and in the field that I need a number with 1 decimal place I chose a decimal data type.Made since to me However, now my numbers do not have the decimals. Please help. |
|
|
vbx
Starting Member
38 Posts |
Posted - 2008-04-16 : 00:08:52
|
| RESOLVED...I just figured in outdata type = decimal (18,0)The zero stands for decimal places...What does the 18 stand for? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-16 : 00:28:22
|
| 18 stands for scale i.e total number of digits that can be stored in decimal field. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-16 : 02:20:58
|
| Precision, Scale, and Length (Transact-SQL)http://msdn2.microsoft.com/en-us/library/ms190476.aspx |
|
|
|
|
|
|
Data type for number with 1 decimal place