title: SQL Server insert into non duplicates
body: <p>Table with objects:</p>
  
  <pre><code>create table objects(
      ID int identity primary key,
      name varchar(50) unique
  )
  </code></pre>
  
  <p>Lets say that we have in a table records <code>a,b,c</code>.
  Inserting new rows given with string example <code>'d,e,f,c,b,d'</code>, using a function changing CSV string to a table and returning it.</p>
  
  <p>I need to insert everything from string example that is not already in objects table, it would be <code>d,e,f</code>. How can I do it? I was thinking about</p>
  
  <pre><code>insert into objects(names)
  select distinct names from split('d,e,f,c,b,d')
  EXCEPT
  select names from objects
  </code></pre>
  
  <p>but I am sure that it has better sollution.</p>