由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Can I use array in SQL stored procedure?
相关主题
SQL debug step into a store procedure from another one (转载)改写(migrate) stored proc 问题
Stored Procedure?如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?
请推荐关于Stored Procedure的书请问怎样找到StoredProcedures的修改记录?
Help: stored procedure in oracle怎么样提高SQL SERVER的编程水平?
请教:how to call a COM object in a stored procedure?【有什么说可以恶补一下data warehousing的知识?】
Stored Procedure的Is和As有什么区别,还有 ······请教有关junior level的database support的面试
[合集] Stored Procedure的Is和As有什么区别,还有 ······SQL server stored procedure 求助
#在SQL里啥子意思Re: Job with Oracle PL? (转载)
相关话题的讨论汇总
话题: stored话题: sql话题: procedure话题: array话题: string
进入Database版参与讨论
1 (共1页)
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

1 (共1页)
进入Database版参与讨论
相关主题
Re: Job with Oracle PL? (转载)请教:how to call a COM object in a stored procedure?
很奇怪为什么大部分人都以为搞计算机的都是在做程序员呢?Stored Procedure的Is和As有什么区别,还有 ······
请问如何DEPLOY STORED PROCEDURE啊[合集] Stored Procedure的Is和As有什么区别,还有 ······
【询问】T-SQL Procedure 比较好的学习资料#在SQL里啥子意思
SQL debug step into a store procedure from another one (转载)改写(migrate) stored proc 问题
Stored Procedure?如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?
请推荐关于Stored Procedure的书请问怎样找到StoredProcedures的修改记录?
Help: stored procedure in oracle怎么样提高SQL SERVER的编程水平?
相关话题的讨论汇总
话题: stored话题: sql话题: procedure话题: array话题: string