How to find total columns?

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'foobar'

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 2

Thanks a lot this works fine

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 3

Can we find total number of columns of a #Table in side a stored procedure

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 4

Hmm, I can't think of a way to do this. Why do you need this?

amish-215805 Old Hand Points: 350 More actions · Answer 5

Hi

You can do like this

select count(*) from tempdb..syscolumns where id = object_id(<temporary table name&gt

Thanks

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 6

Hi amish i tried doing the below statements i am not able to get the results

CREATE tABLE #T

(

A int,

b int

)

select * from #T

Insert into #T (A) values (12)

select * from #T

select count(*) from tempdb..syscolumns where id = object_id('#T')

I want this because

I have a row of data and i want all the columns of this records to be under one header.

Fo i need to loop from 1 to Total number columns to select each column value

and insert it into one column.

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration

Pavas Malviya Ten Centuries Points: 1109 More actions · Answer 7

I got the solution.

We can get the number of columns by usifn the below line of code.

SELECT COUNT(*) FROM tempdb.dbo.syscolumns WHERE [id] = object_id('tempdb.dbo.#T')

Kindest Regards,

Pavas

Dream The Dream
Explore the World
Experince The Exhilaration