Comparing SELECT..INTO and CTAS use cases in Azure SQL Data Warehouse

added by DotNetKicks
3/6/2017 7:09:11 PM

1 Kicks, 240 Views

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.