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 |
|
Muhammad Nasir
Starting Member
10 Posts |
 Posted - 2011-02-02 : 18:08:38
|
| Hi.I'm having a funny thing happening with sql query. Please have a look at the following query and help me out to resolve thisSelect 1/2 as myColand the result i get is "0". Which means that sql server is automatically rounding tha datawhen i write the above mentioned query as belowSelect 1/2.0 as myColNow i get the proper and desired result. I'm wondering that why SQL Server 2005 is behaving like this ? Is it got something to do with Collation settings or something else need to be done to fix it ?please help me on this |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Muhammad Nasir
Starting Member
10 Posts |
Posted - 2011-02-03 : 23:14:10
|
| Thanxs tkizer.. It was really helpful and informative. |
 |
|
|
|
|
|
SQL Server'05 automatically rounding tha numbers