Hi all,
I have a table in microsoft sql azure as emp(empid primary key,identity,sal,dept).
I inserted 10 values like:
empid sal dept
1 2000 3
2 3000 2
3 500 1
. ... .
. ... .
. ... .
10 2000 3
Now I deleted empid from 5 to 10.
Now I am inserting new values it's empid taking from 11 as pid(because i given empid as identity).
now the problem is how can i reset the empid identity from 6.
please any body help to me how can achieve this....
Thanks in advance..........
NOTE:
i tried like below:
1)DBCC CHECKIDENT('emp',RESEED,6)
2) SET IDENTITY_INSERT OFF
insert into emp(empid,sal,dept) values(6,3800,5)
SET IDENTITY_INSERT ON
i tried above to-ways but not get solution. so any body help to me how to do this in another way.