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
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
Nguồn: https://bus-rush.info/
Xem thêm bài viết khác: https://bus-rush.info/cong-nghe/
Can we make an existing column an identity column?
I have got a job 2 months ago
Just because you thank so much sir over and again
can we change the identity after creating the table
Grt
Hi, I am having a problem with one of my tables with regards to identity value. It has a lot of records but the result of DBCC Checkident(tablename,noreseed) is null. Tried to reseed but to no avail or no changes takes place
Thanks, it help me so much
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.
Dear sir,
i have a question, you explained very nicely, but i like to know if without deleting all the records from tblperson1 , if we reseed to 0 again and inserted rows accordingly , so all that id is duplicated how it will be managed.
Regards,
Anindya
Respected Sir, why it is giving us error invalid object name tblperson1
god bless you man !
Awesome teaching method 🤩
Do we have to remember everything in this video?
No#1 tutorial for sql server on youtube … May Allah give you more from your thinkings..
if i want to generate id (abc100111),(abc100112) like what i want to do
Thank you so much for all these videos! They're really easy to understand and helpful!
i have one question like if we sat identity on can we insert duplicate records
Youtube comments are full of amusements sometimes….
https://chrome.google.com/webstore/detail/threelly-ai-for-youtube/dfohlnjmjiipcppekkbhbabjbnikkibo
Sir please help me , If I delete one record from middle of the table and if now i want my id's in serialized order what should I do?
PRANAM GURUDEVA
GURU SAKSHAT PRAMBRHMA
TASMAYE SHREE GURUVE NAMAH !
YOU'RE THE BEST
Sir, your videos are just wonderful.
Can anyone help, I do not do any DBA's work and trying to see whether Constraints & Identity Columns are they used when DBA's try to set data into tables?
Hi Guys.. I am new to SQL. I have a question to ask. I have an already created table. On that i added a new column by using Alter Table ADD. Now my new column is showing all NULL values. But i want to add values to it. There are 15 rows where i need to add values. How do i do that.
extremely clear high level explanation
hi sir, can we reseed the identity column from the middle of the table as clearing the whole table will be difficult
I love your videos! <3
I am amazed at your teaching skill. Thank you sir
Best of Best. thanks for your knowledge sharing.. thanks a lot sir.
Your series is so useful for interview questions ! Thank you Mr. Venkat !
awesome explaination
Please someone clear my doubt. what are the other options available (if any) to DBCC CHECKIDENT command other than 'RESEED'?
'cool'
can we add identity feature to the existing table ? If yes how , i tried to do it in Test environment , but its throwing me error as "it cant done as i need to drop or re create the table "
If we delete some rows, is there any way the SQL server automatically inserts new rows into those gaps? Or is manually toggling IDENTITY_INSERT and inserting the only option?
The best videos for the beginners in SQL-server
Thnk u sir
Your Videos are so helpful! Thank you for sharing
Thank you very much for the tutorial, I learned today a lot, again. Life without learning is pointless and so gray and sad…
You can't alter the existing columns for identity. You have 2 options,
i. Create a new table with identity & drop the existing table.
ii. Create a new column with identity & drop the existing column
Hi
Do I need to learn any programming language b4 I can understand sql ?
Hi Sir, is it possible to add identity constraint to existing table. I have used the query is
alter table tablename add constraint constraintname column
but it is showing error, could you please explain me the possible way to alter the identity constraint
Thank You..!
How to add Identity to an existing column.
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.
Brilliant video, solved a lot of unanswered questions that I had. Thanks