表格来源的最大数量 [英] maximum number of table sources

问题描述

你好，

在SQL Server 2008中，我在单个SELECT查询中可以拥有的表源的最大数量是多少?

谢谢inadvance ..

Hello,

In SQL Server 2008, what is the maximum number of table sources that i can have in a single SELECT query ?

thanks inadvance..

推荐答案

Microsoft说256: http://msdn.microsoft.com/en-us/library/ms177634.aspx [ ^ ]

但是个人呢?我会非常非常努力地将其保持在较低水平，仅出于维护目的...

Microsoft says 256: http://msdn.microsoft.com/en-us/library/ms177634.aspx[^]

But personally? I''d try very, very hard to keep it well down from that just for maintenance purposes...

Google的第一个匹配内容是:

First hit in Google says:

Tables per SELECT statement
Limited only by available resources

http://msdn.microsoft.com/en-us/library/ms143432.aspx [ ^ ]

斯科特

http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]

Scott

这篇关于表格来源的最大数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！