Modify multiple columns in single Alter Table query
<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>