|
|
Posted by Erland Sommarskog on 11/24/06 22:45
serge (sergea@nospam.ehmail.com) writes:
> Two reasons why we chose not to use a single SP with dynamic SQL:
> 1- If we only use dynamic SQL, we are passing the limit for storing
> text and we don't want to use EXEC calls to handle this.
Ah, I see! A workaround or a kludge whichever you want to call it.
On SQL 2005, there is nvarchar(MAX), so there would be limits you could
run into.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|