title: NVARCHAR TO UNIQUEIDENTIFIER Conversion
body: <p>I need to copy data from one SQL table to another table where I need this conversion,
  I tried the following:</p>
  
  <pre><code>SELECT TOP 10 CAST(Per_ID as UniqueIdentifier FROM Test
  
  SELECT TOP 10 CONVERT(UniqueIdentifier,Per_ID,100) FROM Test
  </code></pre>
  
  <p>Both giving me this error:</p>
  
  <blockquote>
    <p>Conversion failed when converting from a character <code>string</code> to <code>uniqueidentifier</code>.</p>
  </blockquote>