title: SQL Server: Returning UniqueIdentifier, Operand type clash: uniqueidentifier is incompatible with int
body: <p>I'm getting this error when trying to return a unique identifier from a stored procedure - thoughts?</p>
  
  <blockquote>
    <p>Operand type clash: uniqueidentifier is incompatible with int </p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>CREATE PROCEDURE TEST
  AS
      RETURN NEWID()
  </code></pre>