title: Save multiple rows in one table in one connection IN sqlserver
body: <p>Scenario: Just consider i have a table having 3 column Id, QuestionId and optedAnswer. I have a form which consists n no of question and some options for answer. On save button i want to save data in database(in my table). </p>
  
  <p>Problem: I want to save all the answers in one connection.</p>
  
  <p>Step taken by me: I made a string having  structure questionId:optedAnswwer | questionId : optedAnswer | and so on....
   I wrote a procedure. started a loop. split the data based on ':' and '|' and saved data in one connection. But it is a rigorous  task. Is there any way to save the data directly without using loop and split.</p>