Table 1: The Four Run Functions

Function Name

Description
RunSP Executes a stored procedure but doesn't return a recordset, making the code more efficient when executing update, insert, or other stored procedures that don't return records.
RunSPReturnRS Executes a stored procedure and returns a recordset.
RunSQL Executes a dynamic SQL statement but doesn't return a recordset, making the code more efficient when executing update, insert, or other stored procedures that don't return records.
RunSQLReturnRS Executes a dynamic SQL statement and returns a recordset.