Navigation:  Actions > Server > Run SQL >

Run SQL Action Input Tab

 Previous pageReturn to chapter overviewNext page

This tab of the Run SQL action configures the SQL statements to be executed.

 

This tab is used to specify the SQL statements to be executed on the server.  This can be a SQL string or a filename containing the SQL statements (required).  A Transact SQL reference is available as well as common SET commands that can be used.

 

Notes:

•Bracket characters [ ] and percent sign % characters within this field must be doubled up (just as in any other field), since these are normally interpreted by  Visual Build as referencing script code and macros within a field.
•If Ignore special characters is checked, the above processing of special characters for macro references and script expressions will not be performed and escaping (doubling) will not be needed.