title: SQL alter column datatype from nvarchar to int
body: <p>Can the datatype of a field be changed to int from nvarchar??</p>
  
  <pre><code>alter table employee alter column designation int
  </code></pre>
  
  <p>is this valid?? If not can it be done in some other way??</p>
  
  <p>P.S: I am using <code>MS SQL Server</code> </p>