blocks|key|4056944|text|要创建表或将其更改为宽表，请向表定义中添加column+set。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4056945|来自here|4056946|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/cc280521.aspx|1|http://msdn.microsoft.com/en-us/library/ms186986.aspx^0|L|A|0|0|2|4|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

"To create or change a table into a wide table, you add a <a href="http://msdn.microsoft.com/en-us/library/cc280521.aspx" rel="nofollow noreferrer">column set</a> to the table definition."

From <a href="http://msdn.microsoft.com/en-us/library/ms186986.aspx" rel="nofollow noreferrer">here</a>

blocks|key|1284587|text|宽表是使用列集和稀疏列的表。它仍然遵循每行相同的宽度限制(8019字节)-所以您通常只在列大多为空时才使用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1284588|有关...的更多信息，请参阅此处|1284589|1284590|special+table+types+in+SQL+2008|unordered-list-item|offset|length|1284591|column+sets|1284592|sparse+columns|1284593|1284594|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms186986.aspx|1|http://msdn.microsoft.com/en-us/library/cc280521.aspx|2|http://msdn.microsoft.com/en-us/library/cc280604.aspx^0|0|0|0|0|V|0|0|0|B|1|0|0|E|2|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|13|8|@]|9|@$H|14|I|15|1|16]]|A|$]]|$1|J|3|K|5|G|7|17|8|@]|9|@$H|18|I|19|1|1A]]|A|$]]|$1|L|3|M|5|G|7|1B|8|@]|9|@$H|1C|I|1D|1|1E]]|A|$]]|$1|N|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]|Y|$5|R|S|T|A|$U|Z]]]]

A wide table is a table that uses column sets and sparse columns. It still follows the same width restrictions per row (8019 bytes) - so you'd typically only use it when your columns are mostly all nulls.

See here for more info on...

<ul>
<li><a href="http://msdn.microsoft.com/en-us/library/ms186986.aspx" rel="noreferrer">special table types in SQL 2008</a></li>
<li><a href="http://msdn.microsoft.com/en-us/library/cc280521.aspx" rel="noreferrer">column sets</a></li>
<li><a href="http://msdn.microsoft.com/en-us/library/cc280604.aspx" rel="noreferrer">sparse columns</a></li>
</ul>

blocks|key|4057071|text|然而，你通常并不想这样做！行有大小限制，检索数据的速度可能比使用相关表慢(即使是那些具有一对一关系的表)。我还没有见过比关联表更好的例子。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4057072|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You usually do not want to do this however! There are size restrictions on the rows and it can be slower to retrieve data than if you use related tables (even those with one-to-one relationships). I've never yet seen an instance where this was a better idea than related tables.

blocks|key|1282932|text|另一个限制是宽表不能用于事务性复制或合并复制。请参阅此处的“支持稀疏列的SQL+Server技术”部分：http://msdn.microsoft.com/en-us/library/cc280604(v=sql.105).aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1282933|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/cc280604(v=sql.105).aspx^0|1G|1S|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Another limitation is that wide tables don't work with transactional or merge replication. See the "SQL Server Technologies That Support Sparse Columns" section here: <a href="http://msdn.microsoft.com/en-us/library/cc280604(v=sql.105).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/cc280604(v=sql.105).aspx</a>

blocks|key|4057092|text|CREATE+TABLE+[UR_DB].[dbo].[DesiredTableName]
(DocID+int+PRIMARY+KEY,
Title+varchar(200)+NOT+NULL,
ProductionSpecification+varchar(20)+SPARSE+NULL,
ProductionLocation+smallint+SPARSE+NULL,
MarketingSurveyGroup+varchar(20)+SPARSE+NULL,
MarketingProgramID+int+SPARSE+NULL,
SpecialPurposeColumns+XML+COLUMN_SET+FOR+ALL_SPARSE_COLUMNS);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4057093|Creating+Complex+Test+Databases+-+Creating+a+Table+with+more+than+1,024+Columns|unstyled|offset|length|4057094|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.msdn.com/b/samlester/archive/2012/08/08/creating-complex-test-databases-creating-a-table-with-more-than-1-024-columns.aspx^0|0|0|27|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code>CREATE TABLE [UR_DB].[dbo].[DesiredTableName]
(DocID int PRIMARY KEY,
Title varchar(200) NOT NULL,
ProductionSpecification varchar(20) SPARSE NULL,
ProductionLocation smallint SPARSE NULL,
MarketingSurveyGroup varchar(20) SPARSE NULL,
MarketingProgramID int SPARSE NULL,
SpecialPurposeColumns XML COLUMN_SET FOR ALL_SPARSE_COLUMNS);
</code></pre>

<a href="http://blogs.msdn.com/b/samlester/archive/2012/08/08/creating-complex-test-databases-creating-a-table-with-more-than-1-024-columns.aspx" rel="nofollow">Creating Complex Test Databases - Creating a Table with more than 1,024 Columns</a>

I was reading the <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="noreferrer">Maximum Capacity Specifications for SQL Server</a> and I came across the designation of a wide table. It's different from a standard table in that is can have as many as 30,000 columns as opposed to a normal (narrow) table that is limited to the more familiar 1024 columns. I googled for wide table, but nothing seem to come up relevant. Does this new table type have a more formal name???

So why do we have two different types of tables, how do you create this special table and what are the limitations of using this table that can seemingly hold more data ? anhyone know ?

How do you create a wide table in SQL Server 2008? and what are its limitations on use?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在看，我偶然发现了一张宽桌的标志。它与标准表的不同之处在于，它可以有多达30,000列，而普通(窄)表仅限于更熟悉的1024列。我在谷歌上搜索了宽桌，但似乎没有找到相关的内容。这个新的表格类型有没有更正式的名字？那么为什么我们有两种不同类型的表，如何创建这个特殊的表，以及使用这个似乎可以容纳更多数据的表的限制是什么...

问如何在SQL Server 2008中创建宽表？它的使用限制是什么？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server 2008中创建宽表？它的使用限制是什么？EN