比如:
CREATE PROCEDURE precedure_test
@i int,
@j int output
AS
set @j=select count(*) from test;
select * from test where id>=@i
GO
在java里调用存储过程,参阅以下连接的文档
http://www.fanqiang.com/a4/b5/20010530/180801279.html
CREATE PROCEDURE precedure_test
@i int,
@j int output
AS
set @j=select count(*) from test;
select * from test where id>=@i
GO
在java里调用存储过程,参阅以下连接的文档
http://www.fanqiang.com/a4/b5/20010530/180801279.html
red 9
blue 6
......