How many columns are allowed? 1

[majorbroncosfan]

I am creating an online application for our current web page. We have over 129
questions or areas gather information for this document. I don't seem to have
any reason to spread any of this information over more than one table, since they
all pertain to the same subject. The problem is that there are 129 columns in
this huge table. Is this normal?

 

[redlam]

SQL can handle up to 1024 columns per base table but you might consider storing your questions in a table like this:
QuestionID
QuestionText
and your answers in a table like this:
AnswerID
QuestionID
AnswerText

 

[majorbroncosfan]

With 129 separate parts, how could I do an upload for the information? Will that come in 129 different queries/subqueries?

To see what I'm working on, you can check it out at

http://www.winnerscorner.net/applications/index.asp

and walk through the app.

 

[redlam]

Ah, I get it now. While there might be a better db design for this - it wouldn't be the one I suggested. I should just stick to the proposed questions... X-)

 

[rajeevnandanmishra]

Hi majorbroncosfan,

Storing information in 129 columns is easy to update and retrieve. But what i think, that, no. of questions must not be the criteria while creating the table. Because, in near future you might want to add some more questions. Then, obviously you have to add more columns.
It is good to distribute information in different tables. So, if in future you want to add a few more questions you can add it easily.