SET IDENTITY_INSERT

 

SET IDENTITY_INSERT (Transact-SQL)

  • Article
  • 2 minutes to read

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics

Allows explicit values to be inserted into the identity column of a table.

Topic link icon Transact-SQL Syntax Conventions

Syntax

syntaxsql
SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }

Comments

Post a Comment

Popular posts from this blog

Time Example

 SELECT distinct td.[CandidateID] ,pc.Description AS Province ,Year(td.Start) ,Day(td.Start) ,cast(td.[Start] as time) [time] ,cast(td.[End] as time) [time]   FROM [hjklhj].[dbo].[TimesheetDetail] AS td      INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID   INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id   WHERE pc.Description = 'CB070000-CPT'    AND Year(Start) = '2021'   AND Month(Start) = '01'
Read more