SQL Server Alter Table add Multiple Column

To insert columns into a table

1. Connect to the Database Engine.
2. From the Standard bar, click New Query.
3. The following example adds two columns to the table dbo.doc_exa. Copy and paste the following example into the query window and click Execute

Alter Table dbo.Lead
add  Title varchar(50) null,
  Phone varchar(50) null,
  LeadSource varchar(50) null,
  LeadSourceDetails varchar(50),
  CustomerSubtypeOther varchar(50),
  InterestDetails varchar(50),
  CustomerSubtype varchar(50),
  Interest varchar(50),
  Street varchar(50),
  City varchar(50),
  [State] varchar(50),
  PostalCode varchar(50),
  Cuntry varchar(50),
  [Description] varchar(100)