In MSSQL, you sometimes want to backup your table(s) before you do something, so in the event you need to roll back, you don’t need to restore the entire database, you can just copy in the data from the newly created table, and dropping the data in your existing table.

To do this, you would simply run:

select * into newtablename from existingtablename