[thelist] MSSQL: dynamic SQL

Brian Cummiskey Brian at hondaswap.com
Tue Jul 26 22:08:15 CDT 2005


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 :)


More information about the thelist mailing list