Question

sql存储过程中，返回值无法获得

存储过程：
et ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[iff_users2]
@blnReturn Int output,
@username CHAR(12)

AS
if exists (select pe_id from [jy2].[dbo].[useruser1] where pe_email=@username)
SET @blnReturn = 1
else
SET @blnReturn = 2

asp:
set rs=server.CreateObject("adodb.recordset")
username="sdzsd"
sql="exec iff_users2 0,'username'"
rs.open sql,conn,3,1
aaa=rs(0)
提示
在对应所需名称或序数的集合中，未找到项目
就是
aaa=rs(0)

这行
怎么回事呀，高手帮我，加分

Answer 1

et ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[iff_users2]
@username CHAR(12)

AS
if exists (select pe_id from [jy2].[dbo].[useruser1] where pe_email=@username)
SET @blnReturn = 1
else
SET @blnReturn = 2

select @blnReturn

asp:
sql="exec iff_users2 'username'"

直接这样就行了....不需要用output

Answer 2

不需要@blnReturn Int output,