How to Reset Primary Key (Auto Increment) Value in SQL Server in Urdu/Hindi

preview_player
Показать описание
Hello Friends welcome to my channel Advance Teaching
This is the part 37 of sql server series ....
in this video we will discuss how to reset primary key auto increment value after deleting record in sql server..
So if you want to learn then must watch this video ....

AND

subscribe my youtube channel Advacne Teaching for latest updates

#advanceteaching
#advanceteachingchannel
#resetprimarykeyinsql
#resetautoincrementinsql

Рекомендации по теме
Комментарии
Автор

Hi sir hum chahtay hain k jab b hum recor delete karain to new record enter kartay he usko next number assign karday. Kia hamay bar bar ye command likna paraiga?q k hamaray pass dabase Mai buhut data hai to hum kis kis number ko beech Mai se check karaingay

shaheentube
Автор

Asslam o Alaikum. Bhai please help me . mery pass database m kuch records hai aur inki id 1 sy start karwai thi aur auto increment b kiya how hai lakin ab jab NEW entry karta hun to wo ID ko 0 dy daita hai aur phir us k baad koi b entry nahi karny daita. Error ata hai k duplicate entry for record 1. please bhai help me to solve my this issue.

MalikMazhar
Автор

Dear I can't truncate table bcz it is being referenced by foreign key constraint.
How to solve it?

ahmadyamout