If you have come to SQL Server from an Oracle, these tips on common tasks may be handy: To do this Oracle syntax SQL Server syntax Create table from SQL select create table NEWTABLE as select * from TABLE select * into NEWTABLE from SOURCETABLE