MS SQL Server: Temporary Tables

Just a way of using temporary tables in Microsoft SQL Server, if you want to duplicate one or more records quickly, you can use commands like this:

This is much shorter if you have 50 fields in your source table. Otherwise, you have to specify each field and their data types;