SQL Server Management Studio:增加结果集中显示的字符数 [英] SQL Server Management Studio: Increase number of characters displayed in result set

问题描述

我有以下场景:我们有存储过程，将我们的开发数据库与我们的客户数据库进行比较，并告诉我们区别是什么(因此，我们必须在客户机器上更新什么).

I have the following scenario: We have stored procedures which compare our developement database to our customer databases and tell us, what the difference is (so, what we have to update on the customer machine).

现在我编写了一些额外的代码来自动生成使客户数据库与我们的开发数据库处于相同状态所需的 CREATE/ALTER/DROP 语句.

Now I wrote some additional code to automatically generate the CREATE/ALTER/DROP statements needed to bring the customer database to the same status as our developement database.

我的代码工作正常，但我在使用 SQL Server Management Studio 时遇到问题:在使用文本输出时，我无法告诉它在结果集中每列显示超过 8192 个字符.有没有办法增加这个数字?

My code works fine, but I have a problem with SQL Server Management Studio: I can't tell it to display more than 8192 characters per column in the result set while using text output. Is there a way to increase this number?

感谢您的帮助！

推荐答案

不认为可以做到.

为了查看您的存储过程，我会使用另一个没有这种限制的工具.

For viewing your stored procedure, I would use another tool which doesn't have that limitation.

这篇关于SQL Server Management Studio:增加结果集中显示的字符数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！