Identity Column in SQL Server - Part 7

In this video we will learn
1. What is Identity column
2. Creating an Identity column
3. Supply explicit values for identity columns using IDENTITY_INSERT
4. Reset identity value using DBCC CHECKIDENT command

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[FinalCounterStrike]

Your teaching style and explanation is much better than any university or college lecturer. I will rate your videos 10/10

[akhileshchander]

Whenever I see a video with a brown background, I know this is the best series and can solve my problem. Thanks

[saitamadecember]

I came here to fix the error at 8:24, It's been a struggle trying to solve. Then I was like, "wait, I had this error before and Venkat solved it. Let me check youtube". And you solved it again, so thank Mr. Venkat, I recommend your videos to all my Software Developer friends, cause you are that good.

[abhiramj]

You should be acknowledged across the industry for providing such a detailed and clear explanation of all the concepts of SQL server!

[Abdikaaf]

I have watched several of your videos and I want to tell you that you're 'A GIFTED MAN FROM GOD'. Honestly!!, you deserve A Nobal Prize. Thank you so much for your help.

[liendefay]

I have been watching your Sql server tutorial videos since yesterday.  You are a wonderful communicator, a great teacher.  Thank you

[Csharp-video-tutorialsBlogspot]

Hi Rajarama, you are absolutely right. Truncating a table, will reset identity column. Thank you for sharing. Really appreciate your time.

[vijaybodkhe]

Your videos explain practical things really helpful.I am seeing this video after 9 years and still useful

[krismaly]

Rewatched since concept or functionality explained clearly. Thanks a lot for educating community

[anuragvashishtha]

Hi Venkat,
A big thanks for such a lucid explanation of Identity column.
Your videos are proving to be enormously useful for me.
Thanks a lot!

[JaswantSingh-goey]

I have got a job 2 months ago
Just because you thank so much sir over and again

[Trzbne]

Thank you very much for the tutorial, I learned today a lot, again. Life without learning is pointless and so gray and sad...

[jyothijangam]

awsome explanation...even a layman can understand ur bless

[Csharp-video-tutorialsBlogspot]

Hi Shravan, this is a very good question. Adding PK and Identity to the same column, will create a clustered index based on the column. Hope this answers your question. Good Luck.

[saadrehman]

No#1 tutorial for sql server on youtube ... May Allah give you more from your thinkings..

[rajmothe]

Your videos made my career man. I am really grateful to you. Thank you so much

[chrischris]

Very helpful video ! Easy to understand and follow along. Thank you!

[Csharp-video-tutorialsBlogspot]

Hi Jojin, in sql server, it is not possible to convert an existing column into an Identity column if the column already exists. However, there are 2 approaches that I can think of to work-around this problem.

Approach 1: Create a new table with identity column, populate this new table with data from the existing table and then drop the existing table.

Approach 2: Add a new identity column to the existing table and drop the existing column.

Hope this helps. Good Luck.

[toothstepper]

WOW you literally have everything on your channel....now I honestly think I wasted my money and time at a Coding Bootcamp

[natavesta]

The best videos for the beginners in SQL-server