Invoking a Stored Procedure

suggest change

To call a stored procedure on the server:

$query = "{call [dbo].[myStoredProcedure](?,?,?)}"; //Parameters '?' includes OUT parameters

$params = array(
    array($name, SQLSRV_PARAM_IN),
    array($age, SQLSRV_PARAM_IN),
    array($count, SQLSRV_PARAM_OUT, SQLSRV_PHPTYPE_INT) //$count must already be initialised
);

$result = sqlsrv_query($conn, $query, $params);

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:


Using SQLSRV:
*Invoking a Stored Procedure

Table Of Contents
19XML
67Using SQLSRV
81PDO
102APCu
108PSR