tsql declare temp table code example Example: sql server: creating temp table by selecting records from other tables SELECT * INTO # FROM WHERE ORDER BY OPTION