Auto Increment ID in Existing Data in database
1st Step: Create SerialId in Table int is Identity Yes Identity Seed:7 digit(0000000) then save. 2nd Step: Create another coloum SerialNo varchar update it with previous SerialId run this query update StyleSize set serialNo = right(cast(SerialId as nvarchar(10)),6)