Search code examples
sql-servernvarchar

Maximum number of nvarchar(max) columns in sql server tables

What is limited of define Nvarchar(max) columns in SQL Server 2008 R2 ?

I see this link

But, I want get limit number of nvarchar(max) columns in one table.

Solution

  • 1024 non-sparse.

    30000 sparse.

    There is nothing special about the column being NVARCHAR(MAX). You won't be able to create a row with that many non-null values, but that is a different topic.