SQLSRV Functions

Table of Contents

• sqlsrv_begin_transaction — Begins a database transaction
• sqlsrv_cancel — Cancels a statement
• sqlsrv_client_info — Returns information about the client and specified connection
• sqlsrv_close — Closes an open connection and releases resources associated with the connection
• sqlsrv_commit — Commits a transaction that was begun with sqlsrv_begin_transaction
• sqlsrv_configure — Changes the driver error handling and logging configurations
• sqlsrv_connect — Opens a connection to a Microsoft SQL Server database
• sqlsrv_errors — Returns error and warning information about the last SQLSRV operation performed
• sqlsrv_execute — Executes a statement prepared with sqlsrv_prepare
• sqlsrv_fetch — Makes the next row in a result set available for reading
• sqlsrv_fetch_array — Returns a row as an array
• sqlsrv_fetch_object — Retrieves the next row of data in a result set as an object
• sqlsrv_field_metadata — Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare or sqlsrv_query
• sqlsrv_free_stmt — Frees all resources for the specified statement
• sqlsrv_get_config — Returns the value of the specified configuration setting
• sqlsrv_get_field — Gets field data from the currently selected row
• sqlsrv_has_rows — Indicates whether the specified statement has rows
• sqlsrv_next_result — Makes the next result of the specified statement active
• sqlsrv_num_fields — Retrieves the number of fields (columns) on a statement
• sqlsrv_num_rows — Retrieves the number of rows in a result set
• sqlsrv_prepare — Prepares a query for execution
• sqlsrv_query — Prepares and executes a query
• sqlsrv_rollback — Rolls back a transaction that was begun with sqlsrv_begin_transaction
• sqlsrv_rows_affected — Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed
• sqlsrv_send_stream_data — Sends data from parameter streams to the server
• sqlsrv_server_info — Returns information about the server