SQL > SQL scripts > SQL script Insert, Delete

SQL scripts containing INSERT INTO, DELETE FROM or UPDATE

When SQL scripts include mixed updating and select statements, terminated with a SELECT statement, the feed back as a standard will be just the output of the SELECT statement.

With PdxEditor including INSERT INTO and/or DELETE FROM statements within the script is sensed, and the sub results are reported along with the SQL SELECT output.

SQLScript-Insert-Delete-Reporting

Likewise, if you execute a script including an INSERT INTO statement, and a terminating SELECT statement, you will be informed if no record are inserted, whatever due to key violations (reported to a separate ERRORINS table) or to other non-met WHERE clauses.

SQLScript-Insert-zero

And here from a script including UPDATE ... SET:

SQLScript-Update-Report