怎么一次可以创建多条存储过程

[kuvske]

在JAVA中想调用事件创建多个存储过程,但'GO'和语句在一行会报错,比如有3个存储过程写成一个String SQL="creater procedure a1_proc as select * from a1 go creater procedure a3_proc as select * from a2 go creater procedure a3_proc as select * from a3 go "; 但在查询分析器中不能执行,问怎么可以写一次可以创建多条存储过程

[s_sgg]

恩.....存储过程后面必须加GO标志吧.....连在一起会报错的话,好象只能分开来创建吧...
JAVA能传个换行过去么?

[marco08]

是 creater 还是 create ?

[cloudtarget]

String SQL="
declare @proc1 varchar(4000)
declare @proc2 varchar(4000)
declare @proc3 varchar(4000)
set @proc1 = 'creater procedure a1_proc as select * from a1 '
set @proc2 = 'creater procedure a1_proc as select * from a1 '
set @proc3 = 'creater procedure a1_proc as select * from a1 '
exec(@proc1 )
exec(@proc2 )
exec(@proc3 )"

[vovo2000]

可以分开来写啊。
String SQL="
declare @proc1 varchar(4000)
declare @proc2 varchar(4000)
declare @proc3 varchar(4000)
set @proc1 = 'creater procedure a1_proc as select * from a1 '
set @proc2 = 'creater procedure a1_proc as select * from a1 '
set @proc3 = 'creater procedure a1_proc as select * from a1 '
exec(@proc1 )
exec(@proc2 )
exec(@proc3 )"

[feixiangVB]

難道在java裏面就是creater嗎???

[s_sgg]

create.....这个是笔误吧..

[kuvske]

不好意思是CREATE是笔误

[kuvske]

在查询分析器里不能执行呀