sql server 2008 对 exec 语句的限制

Question

我只需要仔细检查 t-sql 中的 EXEC 命令是否有字符限制？如果我有一个带有 varchar(max) 的变量并使用 EXEC 执行命令，您认为这样就可以了吗？

谢谢

Answer 1

应该没问题，根据this MSDN article.

相关部分:

Using EXECUTE with a Character String

In earlier versions of SQL Server, character strings are limited to 8,000 bytes. This requires concatenating large strings for dynamic execution. In SQL Server, the varchar(max) and nvarchar(max) data types can be specified that allow for character strings to be up to 2 gigabytes of data.