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 |
|
fasal
Starting Member
2 Posts |
 Posted - 2008-10-30 : 07:09:14
|
| HI, i have a problem with division in sql server. how can i get the digit after decimal point. eg: select 1/2 when i run the above query, the result is 0. i dont get the actual result. how can i solve this issue. any help is appreciated . thanks in advance |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-10-30 : 07:28:45
|
| select 1.0/2.0 |
 |
|
|
fasal
Starting Member
2 Posts |
Posted - 2008-10-30 : 07:41:34
|
| Thanks LoztInSpace solved issue. i have tried same query(select 1/2)in MY SQL it works. i would to know y sql server doesnt show the digits after decimal point. thank in advance |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-30 : 08:09:54
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2008/01/16/beware-of-implicit-conversions.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Problem with division