s*n
2 楼
sql server use "Go" to indicate the end of queries.
I executed a batch queries throught ADO, but it would not recognize "Go".
I would like to know if there is some format for the batch, which can be
executed for sql server and oracle, and also could be executed throught the
ADO APIs? I am more interested in the second.
Thanks a lot!
I executed a batch queries throught ADO, but it would not recognize "Go".
I would like to know if there is some format for the batch, which can be
executed for sql server and oracle, and also could be executed throught the
ADO APIs? I am more interested in the second.
Thanks a lot!
B*g
4 楼
不是很明白,为啥在ADO里一定要放GO呢?
the
【在 s******n 的大作中提到】
: sql server use "Go" to indicate the end of queries.
: I executed a batch queries throught ADO, but it would not recognize "Go".
: I would like to know if there is some format for the batch, which can be
: executed for sql server and oracle, and also could be executed throught the
: ADO APIs? I am more interested in the second.
: Thanks a lot!
the
【在 s******n 的大作中提到】
: sql server use "Go" to indicate the end of queries.
: I executed a batch queries throught ADO, but it would not recognize "Go".
: I would like to know if there is some format for the batch, which can be
: executed for sql server and oracle, and also could be executed throught the
: ADO APIs? I am more interested in the second.
: Thanks a lot!
s*n
8 楼
我不是一定要用GO...只是问问有没有类似这样的分开sql语句的符号。
我是把所有要执行的语句(包括创建sp)放在一个文件里的,然后读取整个文件放到
string, 调用ado api执行。
我主要是不想parse文件, 找出有几条语句, 然后一条一条执行。
实际上是通过ado api执行一个batch sql, 但是这个格式不知道是怎样的。
我只知道sql server是通过加一个GO.
我是把所有要执行的语句(包括创建sp)放在一个文件里的,然后读取整个文件放到
string, 调用ado api执行。
我主要是不想parse文件, 找出有几条语句, 然后一条一条执行。
实际上是通过ado api执行一个batch sql, 但是这个格式不知道是怎样的。
我只知道sql server是通过加一个GO.
s*n
10 楼
我就是要先创建若干个sp,然后在执行sp,
我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
string里, 然后用ADO 执行。
所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
不知道这样讲清楚了没有?
看来只能parse文件了? 或者用ini文件?
我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
string里, 然后用ADO 执行。
所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
不知道这样讲清楚了没有?
看来只能parse文件了? 或者用ini文件?
B*g
14 楼
似乎可以放configure file里边,如果不想hard code的话。
VS deployment tool里边可以这样做。
可以考虑写xml然后存储这个sp,其他语言编的程序也可以用。
【在 s******n 的大作中提到】
: 我就是要先创建若干个sp,然后在执行sp,
: 我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
: 编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
: string里, 然后用ADO 执行。
: 所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
: 不知道这样讲清楚了没有?
: 看来只能parse文件了? 或者用ini文件?
VS deployment tool里边可以这样做。
可以考虑写xml然后存储这个sp,其他语言编的程序也可以用。
【在 s******n 的大作中提到】
: 我就是要先创建若干个sp,然后在执行sp,
: 我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
: 编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
: string里, 然后用ADO 执行。
: 所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
: 不知道这样讲清楚了没有?
: 看来只能parse文件了? 或者用ini文件?
B*g
18 楼
没仔细看,这个和oracle有啥关系?
the
【在 s******n 的大作中提到】
: sql server use "Go" to indicate the end of queries.
: I executed a batch queries throught ADO, but it would not recognize "Go".
: I would like to know if there is some format for the batch, which can be
: executed for sql server and oracle, and also could be executed throught the
: ADO APIs? I am more interested in the second.
: Thanks a lot!
the
【在 s******n 的大作中提到】
: sql server use "Go" to indicate the end of queries.
: I executed a batch queries throught ADO, but it would not recognize "Go".
: I would like to know if there is some format for the batch, which can be
: executed for sql server and oracle, and also could be executed throught the
: ADO APIs? I am more interested in the second.
: Thanks a lot!
相关阅读
Can I do this under MSSQL server?virtual reality or knowledge represntationmysql C APIHow to set up counters on Pentium 4?Question on Exam 1Z0-007 Oracle Certificate网上数据库检索问题。??Column count doesn't match value count at row 1??在webpage上加入多个VEDIO 文件: *.rmneed more free booksoracle installation problem,help![转载] 急:请教:怎样把很宽的EXCEL文件(从A到Q)打印下来呢?Re: how to get a date (get rid of the time part) from a date columns?Export and import question.Get free computer booksHow to find primary keyproblem with IIS->access请问如何在Access中去掉重复的entry?some questions about OQL有没有PostgreSQL的多表多字段查询利器?补充一下Re: 大侠一定要帮我看看呀(关于数据库的更新)