IDENTITY now supported in Azure SQL Data Warehouse

2017年6月26日

Azure SQL Data Warehouse now supports the IDENTITY property for the creation of surrogate keys.

IDENTITY is supported in the following contexts:

  • SELECT..INTO a table with pre-existing IDENTITY column
  • SET IDENTITY_INSERT
  • Loading data into tables with IDENTITY through PolyBase INSERT..SELECT or INSERT..VALUES and BCP
  • sys.identity_columns DMV

The following are currently not supported:

  • IDENTITY()
  • @@IDENTITY
  • SCOPE_IDENTITY
  • IDENT_CURRENT
  • IDENT_INCR
  • IDENT_SEED
  • DBCC CHECK_IDENT()

See the IDENTITY documentation page for more information.

免费帐户

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

免费开始

Visual Studio

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

立即激活

初创企业

加入 BizSpark 计划并获得免费的 Azure 服务

了解更多