How to add 1100 columns in SQL Server I need 1100 columns in a single table.I already have 928 columns in same table, now I need to add new 150 columns.

I know SQL Server allow maximum 1024 columns.

Now I will not create new table. If I create new table and join my require table, I need to make changes in many places and this is not possible for me. So I want to add all columns in same table(require table).I know this is so tough to execute this table but presently I need to serve this requirement.
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.