Oleg Netchaev (8/3/2010)

---

mtillman-921105 (8/3/2010)

---

I think that this "feature" should be changed. Just because two numbers are integers, why assume the answer should also be an integer? :angry:

I would like to disagree with this. The "feature" happens to be default, consistent behaviour in many programming languages. Try this is C#:

int i = 5, j = 3;

Console.WriteLine(i / j);

The above happily prints 1 to the console window. Why would anyone think that T-SQL should behave differently?

<<snip>>

Oleg