我可以在一个表（I.E包含5列）中有多少记录（插入）？ [英] Maximum How Many Records Can I Have(Insert) In A Table(I.E That Contains 5 Columns)?

问题描述

最大可以在表中插入多少条记录（即包含5列）？

maximum how many records can i have(insert) in a table(i.e that contains 5 columns)?

推荐答案

如果你看这里：http://technet.microsoft.com/en-us/library/ms143432(v=sql .105 .aspx [ ^ ] Microsoft发布每个版本的SQL Server的限制。在所有情况下，最大行数取决于可用存储空间，无论列数如何，您都可以拥有内置限制。



请注意，SQL服务器的总数据库大小仅限于524,272太字节，如果您尝试备份整个Google，这可能会成为一个重大问题......

If you look here: http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx[^] Microsoft publish the limits for each version of SQL Server. In all cases, the maximum row count is "dependant on available storage", there is no built in restriction on the number you can have, regardless of the column count.

Be aware though that SQL server is limited to a total database size of only 524,272 terabytes, which may prove a significant problem if you are trying to backup the whole of Google...

这篇关于我可以在一个表（I.E包含5列）中有多少记录（插入）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！