Comparing Execution Functions

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:

• PDO::exec

• PDO::query

• PDO::prepare and PDOStatement::execute.