March 6, 2017
Azure SQL Data Warehouse users now have two options for creating and populating a table in a single statement. The first option is to use CREATE TABLE AS SELECT or CTAS. The second is to use SELECT..INTO. This post summarises the differences between the two approaches.