ETL Testing - SQL Server 2012

-- Creating Temp Table

USE DBNAME;
SELECT [*]/[COLUMNS LIST] INTO #TEMP_TABLE FROM TABLE_NAME;
SELECT * FROM #TEMP_TABLE;
DROP TABLE #TEMP_TABLE;