php调用MsSQL存储过程使用内置RETVAL获取过程中的return值

0

<script language="javascript" type="text/javascript" src="http://static.bshare.cn/b/buttonLite.js#style=-1&amp;uuid=23a3475a-b05e-4ee9-bea7-b3336a11ccf6&amp;pophcol=2&amp;lang=zh"></script><script language="javascript" type="text/javascript" src="http://static.bshare.cn/b/bshareC2.js"></script>

【PHP代码】

$stmt = mssql_init('P__Global_Test', $conn) or die("initialize stored procedure failure"); mssql_bind($stmt, "RETVAL", $returnValue, SQLINT4, true); mssql_execute($stmt, false); if( $returnValue == 0 ){ echo 'ABCD'; } else{

           echo 'EFGH';

}

【存储过程】

CREATE PROCEDURE dbo.P__User_JudgeResume( ) set nocount on set @Message = '' if not exists( select * from _Test ) begin return 0 end else begin return 1 end set nocount off GO