34,590
社区成员
发帖
与我相关
我的任务
分享
<%
'先设置数据连接对象
dim pid,returnchar
pid=10
Set MyComm = Server.CreateObject("ADODB.Command")
with MyComm
.ActiveConnection = conn
.CommandText = "setNormal_p"
.CommandType = 4
.Prepared = true
.Parameters.append .CreateParameter("@P_id",3,1,4,pid)
.Parameters.append .CreateParameter("@ReturnChar",200,2,1000,returnchar)
.Execute
end with
response.write MyComm(1)
set myComm=nothing
%>
create procedure setNormal_p
@P_ID int,
@returnChar varchar (1000) output
as
SET NOCOUNT ON
begin
set @returnChar='abc'
-- return @returnChar
end
go
declare @t varchar(1000)
exec setNormal_p 3,@t output
select @t
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
abc
(1 行受影响)
*/
declare @r varchar(1000)
exec setNormal_p 1,@r output
select @r as result
declare @s varchar(1000)
exec setNormal_p '234',@s out
select @s
字符串是这样返回的