SqlServer2005存储过程的编写（未完待续）

时间：2011-05-18 来源：edisonfeng

1）返回结果为参数

存储过程代码：

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE      getStudentAmount 
@recordCount int output
AS
begin
     select @recordCount=count(*) from studentInfo;
end

测试代码：

XXXXXX

2）返回结果为数据集

存储过程代码：

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE     queryAllStudentInfo
AS
begin
    select * from studentInfo;
end

测试代码：

XXXXXXX

3)访问其他数据库中的表

存储过程代码：

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE get_i_dot
   @i_dot_output int output
AS
BEGIN
   select @i_dot_output=i_dot from fynow..codes where c_code_type=1;
END

注：访问其他数据库中的表，只需用【数据库名】..【表名】的形式即可，eg: fynow..codes

测试代码：

 use EdisonDB;
  
 declare @idot int
 declare @idotString  varchar(10)

 exec get_i_dot  @idot output;
 set @idotString=cast(@idot as varchar)
 print @idotString