SQL Query Runner
Opens a SQL connection, executes a parameterized SELECT query, loads results into a PAD datatable, and closes cleanly.
Sign in or create a free account to copy this script.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
Users hardcode connection strings and forget to close connections, causing pool exhaustion.
Dependencies
- Connection String Builder
- SQL Bulk Inserter