When an SQL statement calls a stored procedure using the ODBC CALL escape clause, the Microsoft® SQL Server™ driver sends the procedure to SQL Server using the remote stored procedure call (RPC) mechanism. RPC requests bypass a lot of statement parsing and parameter processing in SQL Server and are faster than using the Transact-SQL EXECUTE statement.
To run a procedure as an RPC
{? = CALL procname (?,?)}
Note If an application submits a procedure using the Transact-SQL EXECUTE syntax (as opposed to the ODBC CALL escape sequence), the SQL Server ODBC driver passes the procedure call to SQL Server as an SQL statement rather than as an RPC. Also, output parameters are not returned if the Transact-SQL EXECUTE statement is used.
Batching Stored Procedure Calls | Running Stored Procedures |
Calling a Stored Procedure | SQLBindParameter |
Procedures |