sp_executesql

[kevinluk]

I use the sp_executesql to run my dynamic sql within the T-SQL stored procedure, but it blows up when my sql statement grows beyond 4000 bytes limitation. Any idea that I can get around with this limitation? Thanks.

Kevin

 

[NoCoolHandle]

Have you tried just using the execute method?

Create Proc ABC
as
execute('Select some long col list and joins with huge joins')

 

[NoCoolHandle]

Duh.. You would miss out the caching advantage... Sorry

 

[SQLSister]

The other way is to break the statement up into mutiple variables and then concatenate them inthe exec.

Questions about posting. See faq183-874