復制代碼 代碼如下:

<?
$conn=mssql_connect("127.0.0.1","user","passwd");
mssql_select_db("mydb");
$stmt=mssql_init("pr_name",$conn);//
$a=50001;
mssql_bind($stmt,"RETVAL",$val,SQLVARCHAR); //用于直接返回return -103此類的值。
mssql_bind($stmt,"@outvar",$b,SQLVARCHAR,true);//用于返回在存儲過程中定義的輸出參數
mssql_bind($stmt,"@invar",$a,SQLINT4);
$result = mssql_execute($stmt,true);//不能返回結果集，只能得到輸出參數
//$result = mssql_execute($stmt,false); //返回結果集
//$records=mssql_fetch_array($result);
//print_r($records);
//mssql_next_result($result);下一個結果集，當等于FALSE的時候下一個就是輸出參數
echo $b;
echo $val;
?>

復制代碼 代碼如下:

// 初始化要傳進存儲過程的參數們:
$nYear = 2004;
$nPageSize = 20;
$nPageNo = 1;
// Initializes a stored procedure:
$stmt = mssql_init("proc_stat_page", $db_mssql->Link_ID);
// 綁定輸入參數：
mssql_bind($stmt, "@nReturn", $nReturn, SQLINT4, TRUE);
mssql_bind($stmt, "@nYear", $nYear, SQLINT4);
mssql_bind($stmt, "@nPageSize", $nPageSize, SQLINT4);
mssql_bind($stmt, "@nPageNo", $nPageNo, SQLINT4);
// 執行存儲過程，得到QueryID：
$db_mssql->Query_ID = mssql_execute($stmt,false);