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 |
|
elic05
Yak Posting Veteran
62 Posts |
 Posted - 2009-07-26 : 11:25:11
|
| i have a cell that stores smallmoneyif i insert 2.25 i see in the table 2.2500if i insert 5 i see in the table 5.0000how can i change this datatype default behaviour so it won't format my data??? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-07-26 : 12:31:41
|
| but this part of the question belongs here, cause it has to do with administration of the dband the another part of the question has to do with writing a query. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-26 : 18:05:06
|
| make it a Decimal(x, 2) if you want only 2 digits right of the decimal (where x is the total # of digits allowed)See scale and precision in BOL |
|
|
|
|
|
|
how to tell the db not to add trailling zeroes?