In every migration project we provide a set of Developer Tools. One of these useful tools is the SQL Editor.
The advantages of having this tool built-in the application are:
The SQL editor supports any relational database management system (RDBMS) and contains three options:
Divided into two parts:
You can use any DML commands in the SQL editor (query, update, delete and insert and etc)
We often copy an SQL statement, written in one line, directly into the SQL editor. It will be much easier to read the statement if it is well formatted. Clicking on the Format button (F8) while the SQL statement is in the upper pane will format the SQL code.
select CustomerID,CompanyName,Contactname,ContactTitle,Address,City from customers where City='London' and ContactTitle='Sales Agent' order by customerID
SELECT CustomerID, CompanyName, Contactname, ContactTitle, Address, City FROM customers WHERE City='London' AND ContactTitle='Sales Agent' ORDER BY customerID
The History button (F6) will display all the previous SQL statements that were used. Clicking on the desired statement will copy it to the SQL commands area so you can re-run it
You can copy an SQL statement from the Firefly profiler "AS IS" with the parameters and the SQL editor will execute it