title: TSQL: Any benefits for explicitly specifying NVARCHAR in a string?
body: <p>When  you add pass a new <code>job_type</code> to <a href="http://technet.microsoft.com/en-us/library/bb510626.aspx" rel="nofollow noreferrer"><code>sys.sp_cdc_add_job @job_type</code></a>, <br />
  (which is of type <code>nvarchar(20)</code>)</p>
  
  <p>You can pass the argument as either </p>
  
  <ul>
  <li><code>N'</code>cleanup'</li>
  <li>cleanup</li>
  </ul>
  
  <p><strong>Are there any reasons or benefits to use the former syntax using <code>N'</code> to pass the argument to stored procedures?</strong></p>