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.