Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Generating a SQL statement from Interactive SQL result sets

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

Prérequis

You must have executed a query to have a result set to perform the task on.

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

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

Résultat

The statement is copied to the clipboard.

Suivant

Execute the statement generated. You must have the necessary privileges to execute the INSERT, DELETE, or UPDATE statement.