returning only particular column from database??

Question

0.00/5 (No votes)

See more:

SQL-server-2000

, +

I have 10 product id's stored in my database table which has few other columns..but i want to retrieve only the id column from the database and want to update the id which are still empty??

for example if some data is stored in 1,2,3,4,6,8,10 id's whenever i update a new product i want it to be automatically stored at 5th id and next one at 7th id..
is it possible?

Posted 30-Mar-10 22:33pm

hemant_chauhan

Updated 30-Mar-10 22:38pm

PSK_

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**PSK_** · Answer 1 · 2010-03-30T22:46:00

If the column id is of identity type then its not possible to specify your id, in case its not then you can write a function which returns the smallest missing id from the id column.

You can use following query to get the smallest missing id from you table.

Select Top 1 ID + 1 from YourTable T1
where not exists 
   (select * from YourTable T2 where T2.ID = T1.ID + 1)

Jordy "Kaiwa" Ruiter · Answer 2 · 2010-03-30T22:48:00

Solution 2

Hey,

Is there any reason for this approach?

Because it sounds potentially dangerous to me. It could lead to false references if tables are not properly related. Besides that, new rows will always be added to the bottom (as far as i know atleast!)

It all depends on the ID being an AutoNumber or not.

Posted 30-Mar-10 22:48pm

Jordy "Kaiwa" Ruiter

Updated 30-Mar-10 22:49pm

v2

hemant_chauhan · Answer 3 · 2010-03-30T23:06:00

Solution 3

i have changed the application so that it can be easily done...now i only want the id number to be generated whichever is empty in 10 and display and store that id in a offset column without adding any new row...is it possible??

Posted 30-Mar-10 23:06pm