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.
They're integers.

Try:

select 1.0/2.0;


Or:

select CONVERT(NUMERIC,1)/CONVERT(NUMERIC,2);