Check data from temporary table sql

 select * into tablename from #tablename

The SQL query you provided is attempting to create a new table named 'tablename' using the 'SELECT INTO' statement, with the source data being a temporary table named '#tablename'. 

This query selects all columns (*) from the temporary table '#tablename' and inserts them into a new permanent table called 'tablename'. The column names, data types, and constraints from the temporary table will be copied to the new table.

Please note that 'tablename' should be replaced with the desired name for the new table, and '#tablename' should be replaced with the actual name of the temporary table you want to copy the data from.