Comparing SELECT..INTO and CTAS use cases in Azure SQL Data Warehouse
mandag 6. mars 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.