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

ABKYH

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 onset @Message = ''if not exists( select * from _Test )beginreturn 0end elsebeginreturn 1end set nocount off
GO