表可以有多少列和行? [英] how many maximum columns and rows can a table have?
本文介绍了表可以有多少列和行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以知道表有多少行和列?如果我插入1025行输出是什么?以及我可以将多少个最大参数传递给存储过程?
Hi,
Can i know how many maximum rows and columns can a table have ?? if i insert 1025 rows what is the output?? and how many maximum parameters can i pass to a stored procedure?
推荐答案
取决于版本,但MS发布该信息:http://technet.microsoft.com/en-us/library/ms143432.aspx [ ^ ]
Depends on the version, but MS publishes that info: http://technet.microsoft.com/en-us/library/ms143432.aspx[^]
br />
Q 1. sql server 2008中的表中有多少个最大列?
Ans:最大行大小是8,060字节所以它的取决于表中的列类型。
Q 2.每个表最多外键表引用数是多少?
答案:253
Q.3最多嵌套子查询/存储过程/触发器的数量是多少?
答案:32
Q.4用户功能/存储过程中有多少个最大参数?
答案:2100
Q.5最多多少每个SELECT / INSERT / UPDATE语句中的列数?
答案:4096
Q.6 SQl Server中表中有多少行2008年?
http://stackoverflow.com/questions/759244/sql-server-the-maximum-number-of-rows-in-table [ ^ ]
in SQL SERVER 2008
Q 1.How many maximum column can be in a table in sql server 2008?
Ans: Max row size is 8,060 bytes so its depends on column type in a table.
Q 2. How many maximum foreign key table reference per table?
Ans : 253
Q.3 How many maximum nested sub quires/store procedure /triggers ?
Ans: 32
Q.4 How many maximum parameters in user function / store procedure?
Ans : 2100
Q.5 How many maximum number of columns in per SELECT/INSERT/UPDATE statement?
Ans : 4096
Q.6 How many rows in table in SQl Server 2008?
http://stackoverflow.com/questions/759244/sql-server-the-maximum-number-of-rows-in-table[^]
这篇关于表可以有多少列和行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文