We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Write SQL query results to files in a folder, one file per row
Executes the SQL statement and writes each row to a file in the target folder. The first column of the query must be the filename and the second column must be the file content. If two rows produce the same filename the later row overwrites the earlier one. Null content writes an empty file. All output paths must be within a permitted folder.
| Parameter | Description |
|---|---|
| cmd | destination folder path (trailing backslash is optional) |
| Argument 0 | SQL statement whose first column is the filename and second column is the file content |
EmitSqlToFiles "destination folder path (trailing backslash is optional)", "SQL statement whose first column is the filename and second column is the file content"