title: passing multiple parameters to sql procedure as a single string variable
body: <p>From front end(studio 2008) I am passing values to sql procedure as :</p>
  
  <p>string a = "hello" + "098765" + "world" + "90.0909"</p>
  
  <p>These are 4 different values that I've concatenated into a string a;</p>
  
  <p>now i pass this <strong>string a</strong> to the sql procedure using c# sqlCommand object.</p>
  
  <p>Now, how do I retrieve these 4 values in sql procedure as I've created the procedure as:</p>
  
  <pre><code>create procedure Proc_name (@concatenated_string varchar(100))
  as
  insert into table1 values(**how can i get those 4 values here**).
  </code></pre>
  
  <p>I used arrays but it didn't work.</p>