Multiple choice technology databases

What is the maximum number of columns per select statement allowed in SQL 2005?

  1. 1024

  2. 4096

  3. 512

  4. 2048
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL Server 2005 allows a maximum of 4096 columns in a SELECT statement. This is a hard limit in the query processor. Option C (512) was an older SQL Server 6.5 limit, while option A (1024) might be confused with earlier versions or other database constraints.

Keep practicing — related questions