Something like this:
SELECT [Statecode]
,[state]
FROM [scott_test].[dbo].[test]
Statecode state
1 DLI
2 MH
3 UP
2 DLI
select
statecode, state, CAST (0 as integer) as new_column
into #states
from [scott_test].[dbo].[test];
select * from #states;
statecode state new_column
1 DLI 0
2 MH 0
3 UP 0
2 DLI 0
You often need to use CAST/CONVERT to get the new column to be the desired datatype.
Scott