The SQL Options tab allows you to set options for SQL as the output format (as a set of INSERT statements).
Select the ANSI SQL-92 standard or define the type of DBMS you need to export data for (to achieve maximum compatibility). The result script will be generated in compliance with the specifications of the selected server type:
Microsoft® SQL Server™
This group allows you to add the CREATE TABLE statement to the result script, define the name for the table being exported and select SQL dialect.
This group allows you to add the COMMIT statement after a defined number of records or at the end of the script. You can also define the commit statement (COMMIT; by default) in the corresponding edit-box.
This group allows you to customize representation of the NULL values in the result script (NULL by default) and define the character denoting the end of each SQL statement (semicolon by default).