急!一个关于存储过程返回值的问题。(100分!)

ASP页面调用存储过程的代码如下:
Set cmdSalaryCulculate = Server.CreateObject("ADODB.Command")
cmdSalaryCulculate.ActiveConnection = oConn
cmdSalaryCulculate.CommandText = "spSalaryCulculate '"&WorkerID&"','"&StartDate&"','"&EndDate&"'"
cmdSalaryCulculate.Parameters.Append cmdSalaryCulculate.CreateParameter("WindNum", adInteger, adParamReturnValue)
cmdSalaryCulculate.Execute
Response.Write cmdSalaryCulculate(0)
问:
存储过程中的WindNum参数该怎么写?能不能写一段简单的例程。
---------------------------------------------------------------

SQL 2000 books online

Building SQL Server Applications
ADO and SQL Server
Executing Queries
Executing Stored Procedures
Using Return Code and Output Parameters for Stored Procedures
---------------------------------------------------------------

漏了一层

Building SQL Server Applications
ADO and SQL Server
Programming ADO SQL Server Applications
Executing Queries
Executing Stored Procedures
Using Return Code and Output Parameters for Stored Procedures

---------------------------------------------------------------

你应到asp或asp.net的论坛中问
---------------------------------------------------------------

GIVE YOU A EXAMPLE:

CREATE PROCEDURE Usp_Registerlogin
@loginname nvarchar(50),
@password nvarchar(30)
AS

declare @rc int /* SP return code */
set nocount on

select @rc = 0

if @rc = 0
begin
if exists (select * from dbo.employees where cast(loginname as varbinary)=cast(@loginname as varbinary)
begin
select @rc=0
end
else
begin
select @rc=-1
return @rc
end

if exists (select * from dbo.employees where cast([password] as varbinary)=cast(@password
as varbinary))

begin
select @rc=0
return @rc
end
else
begin
select @rc=-2
return @rc
end
end
GO

ASP CALL THIS SP
....
returnvalue=au_adocmd.Parameters("RETURN_VALUE").Value
if returnvalue=3 then
....
conn.RollbackTrans
end if
....

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus