What ADO’s/SQL Server 7’s Query Size Limit is (if (VB)

Topic

New Reply

Hi,

Does anybody know what ADO/SQL Server 7’s Query Size Limit is (if any)? Example, I would like to send very long SQL statements (>8K bytes total length); I also would like to send very long lists of stored procedure parameters (>8K bytes total length); Can ADO/SQL Server 7 handle this?

Thank you!

–Llyal

Reply | Quote

Replies

I’m sorry, but I can’t make sense of that. 8k *bytes*? Or are you talking about 8k *characters*? Why would you have an 8000 character OR byte SQL string? In SQL Server, anything that long should be done in a stored procedure, not as a single query. And I would hate to see any stored procedure that required that much in the way of parameters. Maybe if you explain what you’re trying to accomplish, someone can help you.

Reply | Quote

I am building a database system in SQL Server 7 and one aspect of it will require a table with a few thousand columns; as you can see, filter queries can be quite big (whether I use ADO or stored procedures); I have already found that SQL Server 7 has a column limit of 1024 per table; I am creating a workaround now; I am wondering if there is a query size limit or/and stored procedure parameter size limit that I will need to make a workaround for as well;

I tried to find the limits of SQL server 7 at Microsoft and Google and could not find anything; if you know the answer, I appreciate it; It would be great to know what one can/cannot do with SQL Server so I don’t find “surprises” later;

Thanks,

–Llyal

Reply | Quote

My mind is still boggling over building a table with a “few thousand” columns! I’m sorry but I can’t picture any reasonable relational design that would require thousands of columns in a table, regardless of the database engine you were using. This suggests that your proposed design is entirely unsuitable for SQL Server. If you have already decided to use SQL Server, then you need to change your whole approach and rethink your table designs.

The limits in SQL Server 6.5 were 1962 characters in a row (record) and I doubt that they have increased significantly in SQL Server 7, certainly not to what you envision.

Reply | Quote

Hi,

I found some answers: SQL Server 7 limits stored procedures to 1024 parameters; a SQL string length is over 128KB (no exact number);

Comments of database design- not all Information Systems fit a generic database design model;

Comments on column limits of SQL Server – Oracle DBMS do not have a 1024 column limitation; Microsoft made the 1024 column limitation on SQL Server 7 so that the database could look good in certain kinds of benchmark tests;

I hope this information will be useful to others; I appreciate all the help that I got;

Thanks!

–llyal

Reply | Quote