Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jaiminsarda
Starting Member
1 Post |
Posted - 2008-07-21 : 02:01:11
|
Hi,from my c# code, i am passing a string to a stored procedure.this string has some request ids, separated by a delimiter.e.g. 100|101|102|103|...in my stored procedure, i want to take each id one-by-one and delete records from three tables.Can anybody tell me how do I separate each request id and use it in my stored procedure??Jaimin |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
gregoryagu
Yak Posting Veteran
80 Posts |
Posted - 2008-08-11 : 16:21:05
|
You could use string mystring = "This,is,a,test"; string[] splitstring = mystring.Split(','); foreach (string element in splitstring) { //Do something with element }Greg |
 |
|
|
|
|