SQL
The SQL to be executed. Separate SQL statements with GO on a line by itself. For SQL statements bracketed by a BEGIN and END
statement, do not specify GO within the BEGIN-END block. Here is an example of the correct use of GO to delimit statements:
SELECT * FROM systable
GO
CREATE PROCEDURE p1()
BEGIN
CREATE TABLE t1( pk INTEGER PRIMARY KEY );
INSERT INTO t1 VALUES( 5 );
COMMIT;
END
GO
SELECT * FROM sysprocedure
This command can only be used in a remote task marked as requiring or creating a remote database. The SQL is executed against
the database associated with the remote schema name specified for the remote task.
When executing SQL, the Agent does not COMMIT any statements. If the SQL being execute does not have a COMMIT, the statement
is rolled back. This is important when the SQL is INSERT, UPDATE and DELETE statements or any other statements that do not
explicitly cause a COMMIT.
The status /results for the command store the results of the executed SQL. DDL statements return no results. INSERT/UPDATE/DELETE
statements return the number of rows affected as a single value on a line. SELECT statements return the results in .csv format with column headings as the first row. Results from multiple statements are all appended into one big result.