日志

sqlsrv 执行存储过程

热度 1已有 3921 次阅读2011-7-2 04:09 | sqlsrv

/* Define the Transact-SQL query.

Use question marks (?) in place of the parameters to be passed to the stored procedure */

$tsql_callSP="{call SubtractVacationHours(?,?)}";

$employeeId=4;

$vacationHrs=8;

$params=array(

array($employeeId,SQLSRV_PARAM_IN),

array($vacationHrs,SQLSRV_PARAM_INOUT)

);

/* Execute the query. */

$stmt3=sqlsrv_query($conn,$tsql_callSP,$params);