Microsoft Access 2010中SQL查询的最大长度? [英] Maximum Length of a SQL Query in Microsoft Access 2010?
本文介绍了Microsoft Access 2010中SQL查询的最大长度?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
尝试将159KB TSQL查询复制/粘贴到Microsoft Access 2010直通查询编辑器中(到Microsoft SQL Server 2008后端).
Attempting to copy/paste a 159KB TSQL query into Microsoft Access 2010 passthrough query editor (to a Microsoft SQL Server 2008 backend).
这会产生弹出错误"The text is too long to be edited".
Microsoft Access 2010中查询的最大长度是多少?
What is the maximum length of a query in Microsoft Access 2010?
推荐答案
The help file says that the maximum number of characters in a SQL statement is approximately 64,000. It doesn't mention any difference between pass through queries and other queries, so in the absence of any specific documentation I'm assuming that this also applies to pass through queries.
这篇关于Microsoft Access 2010中SQL查询的最大长度?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
