IDENTITY now supported in Azure SQL Data Warehouse

den 26 juni 2017

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.

Kostnadsfritt konto

Registrera dig nu och få $200 i Azure-kredit

Börja kostnadsfritt

Visual Studio

Prenumeranter får upp till $1800 per år med Azure-tjänster

Aktivera nu

Startups

Gå med i BizSpark-programmet och få Azure-tjänster gratis

Läs mer