Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Adjusting for Deleted Rows

Question:
How do I create a column with a row ID that adjusts if a row is deleted? That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record 4 should become number 3, etc.

Answer:
There's no easy way to create a counter that will adjust every record in the database when a row is deleted. It may seem practical when you're using a small database, but when you have many thousands of rows, such a process would create tremendous delays in accessing the database.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date