Can I use array in SQL stored procedure?# Database - 数据库
j*n
1 楼
If I cannot, how could I keep items in split(string," ") seperately?
Thanks!!
Thanks!!
aw
2 楼
no.
【在 j****n 的大作中提到】
: If I cannot, how could I keep items in split(string," ") seperately?
: Thanks!!
【在 j****n 的大作中提到】
: If I cannot, how could I keep items in split(string," ") seperately?
: Thanks!!
c*g
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!!
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
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
【在 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
相关阅读
Please help数据库这门课值得学吗？各个数据库怎么能连接到外部程序？请教sql server DB 大侠linux下如何打开.sql文件啊？ (转载)#在SQL里啥子意思for round() function in SQLmysql import想学SQL, 请教几个基本问题, 谢谢指教.How to put OBS number into the data?[合集] 数据库这门课值得学吗？change the character set of Accessmysql 如何更新一个表的index啊？[合集] To get the 2nd, 3rd, 4th largest value关于SQL的CERTIFICATIONHow to send BLOB images to remote database?Toad or DBVisualizer如何显示中文？mySQL 问题 (转载)DBA and DB developer问个Access打开方式的问题