title: bulk insertion in MS SQL from a text file
body: <p>I have a text file that contains around 21 lac entries and I want to insert all these entries into a table. Initially I have created one function in c# that read line by line and insert into table but it takes too much time. Please suggest an efficient way to insert these bulk data and that file is containing TAB(4 spaces) as delimiter.<br>
  And that text file also containing some duplicate entries and I don't want to insert those entries.</p>