| 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. |