is there a limit to the number of coulmns you can have in a table?
-
I'm new to SQl and have a client that wants their hard copy survey online.
When we tried putting it all into one table(over 125 columns!), we realised that while the data was being stored on insert. When we went to view the data in our edit page, it showed only some columns.
We used only int and varchar for data types. Most of the questions require a number for the answer.
Any assistance would be greatly appreciated.
Thanks
-
Column limitation per table is 1024... see the following link for complete details...
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
where did you see less columns? You said edit page, is it SSMS or something else?
MohammedU
Microsoft SQL Server MVP -
The more important point is that the correct design calls for at least 4-5 tables with 2-3 columns each. Not 1 table with 125 columns.
-
Yes, thats true in some way to split a single larger table into more than one, but not always neccessary as far as it does not challenge the limit.
-
Next time you go to walmart, imagine trying to find anything if everything was put in a single pile of stuff in the middle of the store.
That's what's going on with this design. While it works it's certainly not friendly for anyone to use. And for one I would not use that store ever.
-
Some people use SQL for the name not for the DB functionality
MohammedU
Microsoft SQL Server MVP -
Ya but then they come back ehre and ask a question where all we can say is here use this 600 line query or redesign the system and use this 3 lines query. And at that point we look like we don't want to or can't help 'em.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply