SQL Server Performance Forum – Threads Archive

what’s the global SET to turn float into int?

I couldn’t find the global SET to turn
int into float, and vise versa. Please help.

---

Well, I figured it out this way:
From your QA, Tools->Options
Connection Tab: check Regional Setting,
in my case, converted numeric into float.
For example:
select 1
output 1.00

---

]]>