create table #Source
(
	SourceID int identity,
	SomeValue varchar(10)
)

insert #Source
select 'Source 1' union all
select 'Source 2'

select * 
into #Test 
from #Source
where 1 = 2

insert #Test
select 'Test'

select * from #Test

drop table #Source
drop table #Test

 SELECT SomeBasicIntColumn = ISNULL(CAST(SomeIdentityColumn AS INT),0),
        other columns
   INTO #SomeTempTable
   FROM dbo.SomeOtherTable
  WHERE 1 = 0
;

SELECT *
INTO dbo.newtable
FROM dbo.oldtable_with_identity
UNION ALL
SELECT TOP (1) *
FROM dbo.oldtable_with_identity
WHERE 1 = 0

 SELECT SomeBasicIntColumn = ISNULL(CAST(SomeIdentityColumn AS INT),0),
        other columns
   INTO #SomeTempTable
   FROM dbo.SomeOtherTable
  WHERE 1 = 0
;

SELECT SomeBasicIntColumn = 0 + SomeIdentityColumn,
        other columns
   INTO #SomeTempTable
   FROM dbo.SomeOtherTable
  WHERE 1 = 0