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
....