Use Identity with an ASP.NET Core app. Learn how to set password requirements (RequireDigit, RequiredLength, RequiredUniqueChars, and more).
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.
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.
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.
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 Entra ID is Microsoft's multitenant, cloud-based directory, and identity management service that combines core directory services, application access management, and identity protection into a single solution.
Learn about agent identities in Microsoft Entra ID, specialized identity constructs that enable secure authentication and authorization for AI agents in enterprise environments.