SQL Tutorial - IDENTITY INSERT

Опубликовано: 21 Август 2017
на канале: BeardedDev

11,208

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 -    • SQL Tutorial - Sequence Objects

Recently Uploaded Videos:
SQL Tutorial - COALESCE, ISNULL -    • SQL TUTORIAL - COALESCE, ISNULL
SQL Tutorial - Create Table with Constraints -    • SQL Tutorial - Create Table with Cons...
SSIS Tutorial - Import and Export Wizard -    • SSIS Tutorial - Import and Export Wizard