how to create temprory table in sql code example

Example: sql server: creating temp table by selecting records from other tables

SELECT *
INTO #
FROM 
WHERE 
ORDER BY 
OPTION