title: How to bulk insert into a table in sql server 2005
body: <p>I have a storedproc which takes an ntext field where some records are passed.
  Suppose there is a table t as below.</p>
  
  <pre><code>| ID | Name | Designation|
  --------------------------
  | 1  | ABC  | Team leader|
  | 2  | DEF  | Developer  |
  | 3  | XYZ  | Manager    |
  </code></pre>
  
  <p>I am sending two more record as '4|Tom|Developer; 5|John|Team Leader;'
  The above string contains column values separated by '|' and rows are separated by ';'.
  So if I pass the string as the ntext type parameter of the storedproc and need to insert the  rows into the table then how to do this? </p>
  
  <p>What is the best way to implement bulk insert in a table in sql server 2005?</p>