Why does SELECT 1/2 return 0?

As the title says. I even tried SELECT CONVERT(NUMERIC, 1/2) which also returned 0.

I am using SQL Server 2008.

First, you are executing the numbers as integers but second, you also have not defined the precision and scale of the numeric datatype.

Try this:

SELECT CONVERT(NUMERIC(5, 2), 1.0/2.0)

or even

SELECT CONVERT(NUMERIC(5, 2), 1/2.0)

StackExchange Database Administrators Q#21650, answer score: 14