The IDENTITY (Function) is used only in a SELECT statement with an INTO table clause to insert an identity column into a new table.
Learn the core concepts of identity and access management (IAM), including authentication, authorization, and identity providers, to secure resources effectively.
Use Identity with an ASP.NET Core app. Learn how to set password requirements (RequireDigit, RequiredLength, RequiredUniqueChars, and more).
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Creates an identity column in a table. This property is used with the CREATE TABLE and ALTER TABLE Transact-SQL statements.
The @@IDENTITY value doesn't revert to a previous setting if the INSERT or SELECT INTO statement or bulk copy fails, or if the transaction is rolled back. Failed statements and transactions can change the current identity for a table and create gaps in the identity column values.
Identity and Access documentation Access and Identity technologies enable secure Active Directory environments on-premises and in cloud-only and hybrid deployments where some applications and services are hosted in the cloud and others are hosted on premises.
Microsoft Identity Manager 2016 extends the reach of Microsoft Entra ID, Microsoft's identity and access management solution. MIM ensures consistent user identities by seamlessly bridging multiple on-premises authoritative systems and authentication stores like Active Directory, SAP, Oracle, and other LDAP and SQL systems.
Learn about agent identities in Microsoft Entra ID, specialized identity constructs that enable secure authentication and authorization for AI agents in enterprise environments.