data retrieving using column index in sqlserver

Question

0.00/5 (No votes)

See more:

Hi experts,

Thank you for attention.

my table

id name loc branch
1 AB Kol
2 Den Den

if i give 0 as column index get 1,2

and how to get no of columns exist in a particular table

Thanks in advance.

please help

Posted 19-Jul-12 22:51pm

Kaushik Saha from Kolkata,India

Updated 19-Jul-12 23:00pm

v2

Add a Solution

2 solutions

Solution 2

Columns count:

SQL

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema=MyDatabase AND table_name = MyTable

Posted 19-Jul-12 22:55pm

OriginalGriff

Comments

Espen Harlinn 20-Jul-12 10:03am

5'ed!

Add a Solution

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

Sebastian T Xavier · Accepted Answer · 2012-07-19T22:55:00

Solution 1

Try this...

SQL

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_CATALOG = 'database' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'table'

Here is another link

sql authority[^]

Hope it helps...

Sebastian

Posted 19-Jul-12 22:55pm

Sebastian T Xavier

Updated 19-Jul-12 22:56pm

v2

Comments

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

now,how to get value using column index not columnname

Espen Harlinn 20-Jul-12 10:03am

5'ed!

Sebastian T Xavier 20-Jul-12 12:21pm

Thanks ...

data retrieving using column index in sqlserver

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

data retrieving using column index in sqlserver

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us