The SQL Query Help Tabs on the Worksheet form is a great feature in SQL 2 Excel Pro which provides help in many ways.
- Browse the database tables and columns to help you write the query. Insert the table and column names into your query with one single click. No typing is needed.
- On-the-fly syntax check provides near instant feedback on the validity of your query. Error message from the database provides hints on where the problem is. Ajax powered for very fast response, almost real time.
- Watch the video below and you'll see it in action!
- Please note that substitution variables are not handled in the dynamic error check. The variables will generate errors in many cases. Workbook variables are not known, or may not even be defined when you write the query in the Worksheet. This is the reason why variables can't be supported. Write your query without variables first. The syntax check will work fine. Replace constants with variables at the end when you are done with the query.
- See the Explain Plan for your query. Advanced users can leverage this to fine tune their queries for optimum performance.
It is very hard to explain in words how this works. So I decided to capture a video which illustrates this. Please play the video below (excuse the poor quality). It will give you an idea how useful these features really are!
(Requires Adbobe Flash)
Please note that this feature does NOT work if you use a Custom Database Driver with SQL 2 Excel Pro It works if you use any of the built in drivers for MySQL, Oracle, MSSQL or postgreSQL - but not with the custom driver.
 |
Subscribe to this comment's feed