sqlsrv_execute - Executes a statement prepared with sqlsrv_prepare
Code Examples

sqlsrv_execute( resource$stmt ): bool

Executes a statement prepared with sqlsrv_prepare. This function is ideal for executing a prepared statement multiple times with different parameter values.



A statement resource returned by sqlsrv_prepare.

Return Values

Returns true on success or false on failure.


When you prepare a statement that uses variables as parameters, the variables are bound to the statement. This means that if you update the values of the variables, the next time you execute the statement it will run with updated parameter values. For statements that you plan to execute only once, use sqlsrv_query.

Related Functions

Example of sqlsrv_execute

Show all examples for sqlsrv_execute

PHP Version: