title: Insert column vaues in Row sql server
body: <p>I am spliting '0021C-15563017-2' on '-' and 
  I want to insert (<code>0021c</code>,<code>15563017</code>,<code>2</code> ) in T2(clntcode,certno.depcode) ,see image .
  I tried the cross apply to insert the split value in a row of the table(img 2) but not working.</p>
  
  <p>The query I have used:</p>
  
  <pre><code>SELECT CLNTCODE, certno, depcode  
  FROM T2  
  CROSS APPLY STRING_SPLIT('0021C-15563017-2', '-');
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/5c0xs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5c0xs.jpg" alt="img 1"></a></p>