PHP calls the MSSQL stored procedure using the built-in retval to get the return value in the process _php tutorial

This article is on the PHP call MSSQL stored procedures using the built-in retval to obtain the return value of the method is described in detail, the need for a friend reference

"PHP Code"

Copy CodeThe code is as follows:
$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 ';

}

"Stored Procedures"

Copy CodeThe code is as follows:

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

http://www.bkjia.com/PHPjc/372472.html www.bkjia.com true http://www.bkjia.com/PHPjc/372472.html techarticle This article is on the PHP call MSSQL stored procedures using the built-in retval to obtain the return value of the method is described in detail, the need for a friend reference under the "PHP Code" copy code ...

