$serverName="localhost";
$connectionInfo = array("UID"=>"sa", "PWD"=>"123456", "Database"=>"master", "CharacterSet"=>"utf-8");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn === false){
die(print_r(sqlsrv_errors(), true));
}
$startMonth = '201901';
$endMonth = '201902';
$params = array(
array($startMonth, SQLSRV_PARAM_IN),
array($endMonth, SQLSRV_PARAM_IN)
);
$sp = "{call p_hslxgb_xxzx(?,?)}";
$stmt = sqlsrv_query($conn, $sp, $params);
if($stmt === false){
die(print_r(sqlsrv_errors(), true));
}
$arr = array();
$n=0;
sqlsrv_next_result($stmt);
sqlsrv_next_result($stmt);
while( $row = sqlsrv_fetch_a
php调用sql server的存储过程(传参版)
最新推荐文章于 2021-04-12 01:06:45 发布
在确保存储过程无误的情况下,使用PHP调用时遇到问题,无法获取返回结果。通过`sqlsrv_next_result($stmt)`两次调用来解决,因为它使得$stmt能包含来自SELECT语句的行,从而可以正确获取数据。
摘要由CSDN通过智能技术生成