php调用MsSQL存储过程使用内置RETVAL获取过程中的return值
0<script language="javascript" type="text/javascript" src="http://static.bshare.cn/b/buttonLite.js#style=-1&uuid=23a3475a-b05e-4ee9-bea7-b3336a11ccf6&pophcol=2&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
页:
[1]