Add column with default value 0.0

Question

I have a table in sql server, but i want to add a extra column full of zeros i do this :

DECLARE @var numeric(10,1) set @var = 0.0
 SELECT tmp.a,
        tmp.b,
        @var
 INTO #tmp2
 from #tmp1 as tmp

when i select * from #tmp2 the column get 0 but i want 0.0

Answer 1

You need to name the columns, this will work as intended leaving the column C with the values 0.0:

CREATE TABLE #temp1(a int, b int)
INSERT #temp1 values(1,1),(2,2)

DECLARE @var numeric(10,1) set @var = 0.0
 SELECT a,
        b,
        @var c
 INTO #tmp2
 FROM #temp1

 SELECT * from #tmp2

Result:

a  b  c
1  1  0.0
2  2  0.0