Overcome 8000 character varchar limit
Posted on 2004-09-03
Our ASP.Net/VB online application allows users to create a customized query to run against a SQL Server 2000 database. The query string is created by passing parameters to a sproc which then assembles the query string and runs it.
When the user selects very many fields for return, this limit is exceeded, and one of the parameters passed from ASP.Net is truncated. Therefore the query string is not constructed and the query can't run.
This can't be the first time this has ever happened, so... what datatype can I use to pass a value when it exceeds 8000 characters? Text? User-defined data type? If so, how?