탐색 건너뛰기

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.

계정 등록

Azure 크레딧 $200을 얻고 인기 서비스를 12개월 간 체험해 보세요.

시작

Visual Studio

최대 $1800 연간 Azure 서비스를 구독자에게 제공

지금 활성화

스타트업

Microsoft for Startups에 참가하고 체험 Azure 서비스 받기

자세한 정보