asp调用sqlserver存储过程返回值问题(在线=)
我写如下2个存储过程,应该怎么样用ASP得到返回值呢?
NO.1
Create Proc pr_Sel_Usr_Nam
(
@Usr_Nam varchar(20),
@Ret_Mes Bit Output
)
as
Begin transaction
If not exists (Select UI_Usr_Nam From T_Usr_Inf Where UI_Usr_Nam = @UI_Usr_Nam)
begin
set @Ret_Mes=0
end
else
begin
set @Ret_Mes=1
end
Go
NO.2
create proc p_test
@cu1 cursor varying output,
@cu2 cursor varying output
as
set @cu1=cursor for select top 5 name from sysobjects where xtype='U'
set @cu2=cursor for select top 5 name from sysobjects where xtype='V'
open @cu1
open @cu2
go
急用