结果查看器无法执行项目列表中超过 655 列的查询 [英] The results viewer cannot execute a query with more than 655 columns in the project list

问题描述

我正在使用 Visual Studio 2008 的服务器资源管理器，我需要在数据库中搜索发票行.所以我找到了一个名为 ixvFact 的表，但是当我尝试检索结果时，visual studio 给了我以下错误并且没有显示结果.

I am using Visual Studio 2008's server explorer and I need to search through a database for invoice lines. So I find this one table named ixvFact but when I try to retrieve the results, visual studio gives me the following error and does not show me the results.

结果查看器无法执行项目列表中超过 655 列的查询.

The results viewer cannot execute a query with more than 655 columns in the project list.

这是什么意思?我该如何解决这个问题?

What does this mean? How can I solve this?

推荐答案

您可以指定要检索的列，而不是从表中选择所有列...我以为在一个列中的列数有限制表...这是非常糟糕的做法...

you can specify the columns you want to retrieve instead of selecting all columns from the table...I thought there was a limit on the number of columns in a table...that's very bad practices...

这篇关于结果查看器无法执行项目列表中超过 655 列的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！