在不同的页大小情况下,表中列的长度和表空间大小:
单列不能超过16384字节:
1> create table tb1(o1 char(16384),o2 char(16385))
2> go
Msg 7327, Level 15, State 2:
Line 1:
Length or precision specification 16385 is not within the range of 1 to 16384.
2K的页:
1> create table tb5(s1 char(1962),s2 char(256))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb5' failed because the minimum row size would be 2220 bytes.
This exceeds the maximum allowable size of a row for this table, 1962 bytes.
4K的页:
1> create table tb1(o1 char(16384),o2 char(16384))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb1' failed because the minimum row size would be 32770 bytes.
This exceeds the maximum allowable size of a row for this table, 4010 bytes.
8K的页:
1> create table tb3(s1 char(4053),s2 char(4054))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb3' failed because the minimum row size would be 8109 bytes.
This exceeds the maximum allowable size of a row for this table, 8106 bytes.
16K的页:
1> create table tb1(t1 char(16297))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb1' failed because the minimum row size would be 16299 bytes.
This exceeds the maximum allowable size of a row for this table, 16298 bytes.
单列不能超过16384字节:
1> create table tb1(o1 char(16384),o2 char(16385))
2> go
Msg 7327, Level 15, State 2:
Line 1:
Length or precision specification 16385 is not within the range of 1 to 16384.
2K的页:
1> create table tb5(s1 char(1962),s2 char(256))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb5' failed because the minimum row size would be 2220 bytes.
This exceeds the maximum allowable size of a row for this table, 1962 bytes.
4K的页:
1> create table tb1(o1 char(16384),o2 char(16384))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb1' failed because the minimum row size would be 32770 bytes.
This exceeds the maximum allowable size of a row for this table, 4010 bytes.
8K的页:
1> create table tb3(s1 char(4053),s2 char(4054))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb3' failed because the minimum row size would be 8109 bytes.
This exceeds the maximum allowable size of a row for this table, 8106 bytes.
16K的页:
1> create table tb1(t1 char(16297))
2> go
Msg 1701, Level 16, State 1:
Line 1:
Creating table 'tb1' failed because the minimum row size would be 16299 bytes.
This exceeds the maximum allowable size of a row for this table, 16298 bytes.