Max no of Columns for a table

[sujitopics]

Hi

Can anybody know how many number of columns we can add to a table in sql [maximum number of coumns]
i mean how many no of columns can a table handle without any pblm
if anybody knows please tell me

yours
suji

 

[RickCole]

The maximum number of columns per table allowed in SQL Server 7.0 or higher is 1024. The maximum number of bytes allowed per row is 8060.

Rick.

 

[sujitopics]

Thankyou VeryMuch