Member Avatar for ssanthosh29

Hello every body,
Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating.
Table 1
Sno SID Name
1 212 Klen
2 213 Lee
3 215 McGrat
etc..
After few days i want to delete ont row from the table

Table 2
Sno SID Name
2 213 Lee
3 215 McGrat

See that Sno I dont want to see 2,3 I want to see like this

Table 3
Sno SID Name
1 213 Lee
2 2i5 Mc Grat
Iwant to see like this table 3:


I should i do thta .Plss Help me

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by madmital
Member Avatar for madmital

You cannot change values in Identity columns - not possible.
If you need to control the values in that particual column(for whatever reason) you need to drop the Identity property and do the whole thing manually.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.