[thelist] MSSQL: dynamic SQL
Brian Cummiskey
Brian at hondaswap.com
Wed Jul 27 11:58:51 CDT 2005
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!
More information about the thelist
mailing list