SQL Tutorial - IDENTITY INSERT

Описание

Another fantastic SQL Tutorial brought you by BeardedDev.

Tutorials on SQL Querying, SQL Development, Database Administration, Data Analysis and Business Intelligence.

Subscribe to the channel for more fantastic tutorials.

This video contains everything you need to know about IDENTITY_INSERT in SQL Server with working examples.

IDENTITY_INSERT allows us to explicitly INSERT values in to a column with an IDENTITY property.

Find out all columns that have an identity property:
SELECT * FROM sys.columns
WHERE is_identity = 1

Always remember to set IDENTITY_INSERT OFF

Syntax:

SET IDENTITY_INSERT [table] ON;

[INSERT Statement]

SET IDENTITY_INSERT [table] OFF;

Associated Videos:
Create Table with Constraints - https://youtu.be/FsVpkamX--Q

Recently Uploaded Videos:
SQL Tutorial - COALESCE, ISNULL - https://youtu.be/Cn-r775hcJE
SQL Tutorial - Create Table with Constraints - https://youtu.be/bfBnZKf2EGg
SSIS Tutorial - Import and Export Wizard - https://youtu.be/-ZAbo8ZOsmY