How to SELECT * INTO [tmp table] without declare table?

Viewed 62944

i want use select statement on the a table and inserting result into a temp table variable, but i don't declare temp table with columns and i want use like this:

Declare #tmp table;

SELECT * INTO #tmp FROM myTable

this want declare columns and data types for #tmp

please help me

2 Answers
Related