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 |
|
chiragvm
Yak Posting Veteran
65 Posts |
 Posted - 2007-07-14 : 05:53:42
|
| Hi to all I have one problem regarding sp and pass value in sp I am gating a value like Abc,Def,Ghi,Now I want to split the whole pass value by “,”And fire one for loop to store value in database This things is done in asp.net web form but I want to do all process in sp So please guide me how I am write sp . The purpose is pass value one time so connection time is decrees and give fast perforce |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-14 : 06:13:10
|
| There are many functions available for this. Search for "split" or "fnparsestring" or "fnparselist".Peter LarssonHelsingborg, Sweden |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
split value in sql