Generating SQL statements from result sets

You can create INSERT, DELETE, and UPDATE statements for selected rows in the result set.

 To generate SQL statements from an Interactive SQL result set

  1. Select the row(s) you want to generate a statement for.

  2. Right-click the selection, and choose Generate, and then choose INSERT Statement, DELETE Statement, or UPDATE Statement.

    The statement is copied to the clipboard.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0