SQL Server Specification Limits - Maximum Columns allowed in SELECT, INSERT and UPDATE Queries

By Santhosh N

This explains about the limitation of the number of columns allowed in the SELECT, INSERT and UPDATE Queries in the SQL Server.

SQL Server imposes the number of columns that can be allowed in the SELECT or INSERT  or UPDATE Query and it allows a maximum of 4,096 Columns.


Note: This hold common for both 32-bit and 64-bit SQL Server.

Related FAQs

This explains the maximum number of columns allowed for keys (Primary, index and foreign keys) in SQL Server.
This explains the maximum size in bytes that is allowed for keys (Primary, index and foreign keys) in SQL Server.
This explains the maximum size of the STRING Data type Columns’ value allowed by the SQL Server.
This explains the best scenarios to create CLUSTERED index on the table in SQL Server.
This explains about the creation of NON-CLUSTERED indexes and maximum allowed.
This explains about the maximum number of parameters allowed in Stored Procedures and functions in SQL Server 2008 R2.
SQL Server Specification Limits - Maximum Columns allowed in SELECT, INSERT and UPDATE Queries  (1387 Views)