[thelist] MSSQL: dynamic SQL

[Brian Cummiskey]

Brian Cummiskey wrote:
> Jason Handby wrote:
> 
>>
>> So you can build your long command in separate varchar variables, each
>> of which is <= 8000 bytes, and then do something like this:
>>
>>     EXEC (@MyBigVarChar1 + @MyBigVarChar2 + @MyBigVarChar3)
>>
>>  
>>
> 
> Thanks Jason.  I'll try this tomorrow when i'm at the office :)

That did the trick, Jason.  Thanks!