create temp table with columns types code example
Example: Best way to create a temp table with same columns and type as a permanent table
select top 0 *
into #mytemptable
from myrealtable
select top 0 *
into #mytemptable
from myrealtable