Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

force single statement (true\false) - if set to true, and there are multiple statements in the query definition, will force the query to be submitted to the server as one statement.This execution path should be used if the query has a semi-colon in the text of the SQL statement. This is a legitimate condition if there is (for example) a statement with a where-clause that has a semi-colon.

e.g.: UPDATE sometable SET somecolumn='val1;val2' WHERE somecolumn='val3;val4'

multi-statement separator (single character value) - defaults to ';". Allows you to change the statement separator when multiple sql statements are present

...