title: What is the use of writing N' ' in query sql server
body: <p>I am using <code>sql-server 2012</code> and I have this query </p>
  
  <pre><code>create table t
  ( 
  id int not null,
  name varchar(10)
  );
  
  
  select OBJECT_NAME(object_id) as table_name,type,name as table_name,type_dec
  from sys.indexes
  where object_id=OBJECT_ID(N'dbo.t',N'U')
  </code></pre>
  
  <p>whats the difference in <code>object_id and OBJECT_ID</code>
  and what is the use of writing <code>N''</code>  </p>
  
  <p>The query returns same result: with or without <code>N</code>
  <img src="https://i.stack.imgur.com/B1w7a.png" alt="enter image description here"></p>