SQL Server 'select * into' versus 'insert into ..select *

SQL Server 'select * into' versus 'insert into ..select *

sql-server select-into

sql-server

Preserving ORDER BY in SELECT INTO

sql-server tsql sql-order-by select-into

sql-server

There is already an object named 'tbltable1' in the database

sql sql-server sql-server-2005 select-into

sql-server