Just wanted to know if there is a limit to the number of fields a table can have in MSSQL 2000.
2006-10-04 16:58:39 · 5 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
1024 columns is the max
http://www.sql-server-helper.com/sql-server-2005/maximum-capacity-specifications.aspx
2006-10-04 17:08:36 · answer #1 · answered by Stanley 3 · 0⤊ 0⤋
I dont know about the number of columns you can store, but yes, there is something called the row size. It is limited to 8K in SQL Server 2000. So even if you have a table with 100 columns each varchar 2000, the table will be created. But as soon as you start using more than 8K for a single row, SQL Server starts truncating the data. Take a look at the following URL for more info.
This problem may have been fixed in more recent releases of SQL Server though. All the best!!!
2006-10-04 17:14:46 · answer #2 · answered by Dhruv 3 · 0⤊ 0⤋
i'm in favour of limiting the style of remote places gamers to 4. IPL is rather an Indian family members journey with India as their known marketplace which provides international gamers an probability to earn plenty extra beneficial than what they are in a position to by taking part in for their nationwide area. i'm no longer against remote places gamers engaging in the Indian family members journey, yet i've got faith 4 is in basic terms the desirable type for terribly final XI. The family members gamers could settle for extra opportunities and exposures. additionally, having 5 or extra remote places ability having some 2d rated gamers from different international places and that i'm completely against it. As for a international league, we've already got CLT T20.
2016-12-26 10:05:16 · answer #3 · answered by Anonymous · 0⤊ 0⤋
What's a MSSQL 2000?
2006-10-04 16:59:48 · answer #4 · answered by Roxy 2 · 0⤊ 2⤋
As far as I know, there is no limit.
2006-10-04 17:03:57 · answer #5 · answered by Goffik 6 · 0⤊ 1⤋