table.hovertable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
table.hovertable th {
background-color:#c3dde0;
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
table.hovertable tr {
background-color:#d4e3e5;
}
table.hovertable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
What are the maximum number of Characters per varchar(max) column in SQL Server?
SQL Server Supports 2^30-1 Characters per varchar(max) Column.
Max Capacity For | SQL Server 2012 | SQL Server 2008 R2 | SQL Server 2008 | SQL Server 2005 |
---|---|---|---|---|
Maximum number of Characters per varchar(max) column in SQL Server | 2^30-1 Bytes | 2^30-1 Bytes | 2^30-1 Bytes | 2^30-1 Bytes |