27,579
社区成员
发帖
与我相关
我的任务
分享
<%
Set MyComm = Server.CreateObject("ADODB.Command")
dCmdSPStoredProc = 4
adParamReturnValue = 4
adParaminput = 1
adParamOutput = 2
adInteger = 3
adVarChar = 200
adVarWChar = 202
with MyComm
.ActiveConnection = Conn
.CommandText = "power_show_p"
.CommandType = 4
.Prepared = true
set rs=.Execute
end with
response.Write(rs.recordcount)
%>
存储过程如下:
[code=sql]
create procedure power_show_p
as
SET NOCOUNT ON
begin
select * from second_t
end