retrieve data from a column by column index not columnname

Question

0.00/5 (No votes)

See more:

hi expert,

I am grateful for your attention.

My Table

id name department   salary
1   ABC              100000
2   ABD Accounts      76000
3   ADE Testing       59000

if i give the column index of department

then I want to get like

department
----------
Accounts
Testing

How the problem will be solve.

please help.

Thanks in advance.

Posted 20-Jul-12 0:27am

Kaushik Saha from Kolkata,India

Updated 20-Jul-12 0:39am

Mehdi Gholam

v2

Add a Solution

Comments

Sandeep Mewara 20-Jul-12 7:26am

Elaborate what you mean here by an example. Also, do share why are you trying to do such thing.

3 solutions

Solution 1

Use :

SQL

select distinct [department] from [tablename]

Posted 20-Jul-12 0:40am

Mehdi Gholam

Comments

Kaushik Saha from Kolkata,India 20-Jul-12 6:50am

Thanks for your answer.But I have to retrieve using columnIndex not columnname

Solution 2

Hi....

U can use below query.

SQL

select distinct(department) from tblname

Posted 20-Jul-12 0:49am

Arul R Ece

Comments

Kaushik Saha from Kolkata,India 20-Jul-12 7:14am

Thanks for your answer.But I have to retrieve using columnIndex not columnname.
It is already mentioned in my question.

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)

Santhosh Kumar Jayaraman · Accepted Answer · 2012-07-20T01:18:00

Solution 3

This will work.

SQL

declare @columnname as varchar(500)
declare @tablename as varchar(500)
declare @Columnindex as int
declare @query as nvarchar(max)

--table name
set @tablename='attendance2'

--column index
set @Columnindex=1
select @columnname= COLUMN_NAME from INFORMATION_SCHEMA.Columns
 where ORDINAL_POSITION=@Columnindex and TABLE_NAME=@tablename

set @query='select ' + @columnname +' From '+@tablename
exec sp_executesql @query

Posted 20-Jul-12 1:18am

Santhosh Kumar Jayaraman

Comments

Kaushik Saha from Kolkata,India 20-Jul-12 8:03am

Thank you very much.working smoothly by your code.

Santhosh Kumar Jayaraman 20-Jul-12 8:10am

Thats my pleasure!!!