php 存储过程输出,PHP 存储过程返回值 SQL SERVER 2008

Microsoft Drivers for PHP for SQL Server 中 SQL SERVER 2008

PHP.ini

[PHP_PDO_SQLSRV]

extension=php_pdo_sqlsrv_53_ts_vc6.dll

[PHP_SQLSRV]

extension=php_sqlsrv_53_ts_vc6.dll

PHP code

$ReturnID=1.0;

$tsql_callSP = "{call Insert_Out(?,?)}";

$params = array(

array($TypeId, SQLSRV_PARAM_IN),

array($ReturnID, SQLSRV_PARAM_OUT)

);

$stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);

if( $stmt3 )

{

echo "返回的插入ID是: $ReturnID
";

}

else {

die( print_r( sqlsrv_errors(), true));

}

SQL Server Procedure

ALTER proc [dbo].[Insert_Out](

@TypeId nvarchar(32),

@ReturnID int OUTPUT

)

as

BEGIN

SET @ReturnID=9999;

return @ReturnID;

END

执行PHP 后功调用存储过程，但$ReturnID 无法得到9999值