Comparing Execution Functions

SQL Server 2008 R2

The Microsoft Drivers for PHP for SQL Server provides several options for executing functions.

If you are using the SQLSRV driver, use sqlsrv_query to execute a single query and sqlsrv_prepare with sqlsrv_execute to execute a prepared statement multiple times with different parameter values for each execution.

If you are using the PDO_SQLSRV driver, you can execute a query with one of the following: