About SQL Queries

DBEdit uses normal text files that contain queries as SQL files.

These offer the following advantages:

  • SQL files allow procedural scripting. You can create a series of statements and have them executed as a batch.
  • SQL files allow scripting the queries in the exact order they are needed, which should make it easier for Customer Care to update the database during an upgrade. Previously, when creating *.dbq files, users had to specify the sequence of the queries to be run.
  • SQL files provide a familiar look and feel much like the Isql query environment of Sql Server. They also support the same commenting syntax.
  • Queries can be individually highlighted and invoked.

DbEdit has a query executor, which has an interface similar to Microsoft SQL Server Management Studio.

Sample SQL query