How to add 1100 columns in SQL Server
Bad idea, but if you insist and your data qualifies for the 8K bytes limitation -  

Wide Tables


  A wide table is a table that has defined a column set. Wide tables use
  sparse columns to increase the total of columns that a table can have
  to 30,000. The number of indexes and statistics is also increased to
  1,000 and 30,000, respectively. The maximum size of a wide table row
  is 8,019 bytes. Therefore, most of the data in any particular row
  should be NULL. To create or change a table into a wide table, you add
  a column set to the table definition. The maximum number of nonsparse
  columns plus computed columns in a wide table remains 1,024. By using
  wide tables, you can create flexible schemas within an application.
  You can add or drop columns whenever you want. Keep in mind that using
  wide tables has unique performance considerations, such as increased
  run-time and compile-time memory requirements. For more information,
  see Performance Considerations for Wide Tables.