SQL Data - Insert Into Undeclared Temp Table

Atron Seige
Developer

It is sometimes difficult to create a temp table that matches the source.
Sometimes it is not properly documented, or changes without your knowledge.

By using INTO without declaring the temp table first SQL will create a matching table.

SELECT
	*
INTO #Bubbles
FROM dbo.tableName