title: What is the meaning of the prefix N in T-SQL statements and when should I use it?
body: <p>I have seen prefix N in some insert T-SQL queries. Many people have used <code>N</code> before inserting the value in a table.</p>
  
  <p>I searched, but I was not able to understand what is the purpose of including the <code>N</code> before inserting any strings into the table.</p>
  
  <pre><code>INSERT INTO Personnel.Employees
  VALUES(N'29730', N'Philippe', N'Horsford', 20.05, 1),
  </code></pre>
  
  <p>What purpose does this 'N' prefix serve, and when should it be used?</p>