title: Changing all varchar columns in a SQL Server database to nvarchar
body: <p>I am trying to update all <code>varchar</code> columns in a database to <code>nvarchar</code> without losing the data.</p>
  
  <p>I have the following query:</p>
  
  <pre><code>select * 
  from INFORMATION_SCHEMA.COLUMNS 
  where DATA_TYPE = 'varchar'
  </code></pre>
  
  <p>How do I modify this to update the columns it finds and have that reflected throughout the database?</p>