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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 我就是要先创建若干个sp,然后在执行sp,
: 我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
: 编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
: string里, 然后用ADO 执行。
: 所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
: 不知道这样讲清楚了没有?
: 看来只能parse文件了? 或者用ini文件?
VS deployment tool里边可以这样做。
可以考虑写xml然后存储这个sp,其他语言编的程序也可以用。
【在 s******n 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 我就是要先创建若干个sp,然后在执行sp,
: 我的这些sp是很长的, 不想直接hard code, 而且如果sp有问题, 也不想需要重新
: 编译程序, 所以我把他们放在一个文件里, 又不想parse文件, 想直接读到
: string里, 然后用ADO 执行。
: 所以我需要知道如果用ado执行batch, 这个语句间是用什么分隔的?
: 不知道这样讲清楚了没有?
: 看来只能parse文件了? 或者用ini文件?
B*g
18 楼
没仔细看,这个和oracle有啥关系?
the
【在 s******n 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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!
相关阅读
is there such DB available?[转载] SQL Server 2000Re: Help! who have ever designed the LOGOUT function in a webpage?谢谢skeptic,高低价,amnesia 三位大侠hiThe Question About Access !Oracle8起动求助db2 charactor 的数据类型Question : how to dynamically line an Exel graph into a VB programQuestion about MySQLHelp wanted for buying computer textbookserror 12154请问在MSSQL server7里如何输入图像呢?Where can I download Personnal Oracle7Multimedia database PerformanceHelp! who have ever designed the LOGOUT function in a webpage?请问sambar: SQL Server数据同步复制的问题question for webdb guruIntroduction book关于数据仓库的讨论