|
This page
controls the formatting of INSERT/DELETE/UPDATE statements
generated by DataDiff.
Batch
rows. Specifies whether to send
each statement to the server separately or in a batch of N rows.
Specify 0 to put all SQL in one batch (no delimiters between
statements), 1 to put a delimiter after each one, or a larger
number to group every N statements.
Always
specify columns. If checked, INSERT INTO
will always contain the list of columns for which the data is
inserted. Otherwise, the list will be omitted if the statement
inserts all
columns
(which makes for much shorter SQL code, but may cause unexpected
errors if the table structure changes).
Datetime
format. The program can
generate datetime literals in any of the predefined formats
supported by MS SQL Server (see MS Transact-SQL documentation for
the description of format
parameter of
the CONVERT() function). Additionally, you can tell the program to
include the explicit CONVERT as well, thus ensuring that the string
representing the date will be correctly converted into datetime
value regarding of default datetime format set on the
server.
|
