56,687
社区成员
发帖
与我相关
我的任务
分享
$name = '1as5d4as564';
$count = 0;
//参数需要以如下数组方式赋值并标明类型,SQLSRV_PARAM_IN是输入类型,SQLSRV_PARAM_OUT是输出类型。注意要按照存储过程定义的顺序赋值
$params = array(
array(&$name, SQLSRV_PARAM_IN),
array(&$count, SQLSRV_PARAM_OUT)
);
$tsql_callSP = "{call prSearchcontentshow(?,?)}";
$stmt3 = sqlsrv_query($conn, $tsql_callSP, $params);
if( $stmt3 === false )
{
echo "Error in executing statement 3.\n";
die( print_r( sqlsrv_errors(), true));
}
print_r($params);
create procedure prSearchcontentshow(
@name varchar(50),
@counts int output
)
as
begin
//insert into Alarm values(@name); 如果加上这一句输出参数就不能正常返回
set @counts = 6666;
end