Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 running an excute(@QStr) when @QStr is longer than 124 bytes

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-19 : 00:05:23
paul writes "I am running this code in a stored procedure on SQL SERVER 6.5 on an NT box.

when I try to run the following code

select @QStr = 'select col1, col2,...
...
...
GROUP BY col2, col4'

exec(@QStr)

I get an error telling me that the execute statement can only be 124 bytes. Is there any way around this?

Paul"
   

- Advertisement -