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 |
|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 2008-09-24 : 01:44:09
|
| In my table one column NAME is ACD i am taking ACD=column1/column2And the final result i am taking ACD<0.5 DATA which data type i need to give for the ACD if i give float sum result is not calulating please solve this one |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 01:48:05
|
| [code]float is ok if you're not much concerned about accuracy of decimal part. If you're looking for accurate decimal result use decimal(p,s) or numeric(p,s) where p is precision and s is scale.Look into books online for more details[/code]http://doc.ddart.net/mssql/sql70/de-dz_1.htm |
 |
|
|
|
|
|
REGARDING THE DATA TYPE IN SQL