title: Modify multiple columns in single Alter Table query
body: <p>Is there a way to modify multiple columns in one sql query? For example I want to change the column definition of multiple columns in single table as follows. I am using SQL server 2012.</p>
  
  <pre><code>ALTER TABLE [Department]     
  ALTER COLUMN [DepartmentName] VARCHAR(200) NULL ,
  [ProjectManagerName] VARCHAR(200) NULL ,
  [AccountManagerName] VARCHAR(200) NULL 
  </code></pre>