Hello,<br> I am relatively new to SQL server and have been asked to set up a table which consists of around 1000 columns, which would all be the integer data type.<br> Could somebody advise me on the quickest way of doing this.<br><br>Cheers....Paul<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lots Of Columns
- Thread starter grimmy
- Start date
When you say <i>around 1000 columns</i>, keep in mind that there is a hard limit of 1024 columns in any one table in SQL Server 7 (only 250 in v. 6.5).<br><br>I don't know of any simple way, except to copy and paste in the Query Analyzer when building the <FONT FACE=monospace>create table</font> statement. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Status
Similar threads
- Locked
- Question