j****n 发帖数: 107 | 1 If I cannot, how could I keep items in split(string," ") seperately?
Thanks!! | aw 发帖数: 127 | 2 no.
【在 j****n 的大作中提到】 : If I cannot, how could I keep items in split(string," ") seperately? : Thanks!!
| c**g 发帖数: 274 | 3 use a loop and charindex function.
Usually I join an array of String by ":", pass this joined string
as a single varchar parameter to stored procedure, then in
the stored procedure, a loop and charindex function go through
all of them. Can't write down the code without my reference. I
always copy/paste.
My bad memory really gave me a hard time during my job hunting
back years ago. I just can't remeber the syntax. It is the most embarrasing
moment when asked to wring code on paper, what a nightma
【在 j****n 的大作中提到】 : If I cannot, how could I keep items in split(string," ") seperately? : Thanks!!
| j****n 发帖数: 107 | 4 谢谢,我最后也是用这个办法做的。
【在 c**g 的大作中提到】 : use a loop and charindex function. : Usually I join an array of String by ":", pass this joined string : as a single varchar parameter to stored procedure, then in : the stored procedure, a loop and charindex function go through : all of them. Can't write down the code without my reference. I : always copy/paste. : My bad memory really gave me a hard time during my job hunting : back years ago. I just can't remeber the syntax. It is the most embarrasing : moment when asked to wring code on paper, what a nightma
|
|