Versions Compared

Key

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

...

Executing the above SQL will result in the following prompt window:

Image RemovedImage Added

Using variables with no data type defined shows these as Literal. This means that the specified value will replace the variable as-is in the SQL statement.

...

This example use the full capabilities of variables. This example is generated by the Script to SQL Commander->INSERT COPY INTO TABLE right click menu choice in the Data tab grid. By default it generates variables representing the actual values and the characteristics of the columns.

Image RemovedImage Added

To highlight that a variable is part of the WHERE clause in the final SQL, it is represented with a green symbol in front of the name.

...