跳过导航

SELECT..INTO comes to Azure SQL Data Warehouse

2017年3月15日

You can now use SELECT..INTO in your SQL code when you want to persist the results of a SELECT statement into a table.

The SELECT..INTO syntax is streamlined. With very little effort, your results will be stored in a round_robin clustered columnstore. From there, you can conduct further analysis as required. Azure SQL Data Warehouse also continues to support CREATE TABLE AS SELECT (CTAS).

CTAS affords greater control on the structure of the resulting table but requires a little more effort on your part. To compare SELECT..INTO to CTAS, please refer to the recent blog post and product documentation, which highlight the differences between these approaches.

免费帐户

免费获得 $200 的 Azure 额度和 12 个月的常见服务使用权。

免费开始

Visual Studio

订阅者每年可获得高达 $1800 的 Azure 服务

立即激活

初创企业

加入 Microsoft 初创企业用户行列,获得免费的 Azure 服务

了解更多