Common Actions in the Query Panel

Command Palette

The complete list of available editor functions can be accessed through out Command Palette by typing Command+Shift+P on Mac or the Ctrl+Shift+P button within the editor or from the View->Command Palette menu item.

mceclip4.png

 

Renaming Tabs

You can rename the query tabs by double-clicking and typing in a name as shown below.

mceclip5.png

 

Commenting SQL

In Aginity Pro you can use the typical SQL syntax to comment your code as shown below

1
2
3
4
5
6
-- This is one way to comment your SQL code

SELECT AVG(LineTotal)
FROM sales.SalesOrderDetail

/* This is another way to comment your SQL code */
Hint
If highlight multiple lines of code you can also use the Shortcut Keys Ctrl+K+C on Windows or Command+K+C on Mac to comment them out. To uncomment use Ctrl+K+U or Command+K+U.

 

Keeping Connection

The Keep Connection checkbox as shown below will instruct Aginity Pro to maintain the connection to the database if the default behavior of the database is to disconnect after the execution of a query. You are still subject to an overall database connection timeout if your session connection exceeds the permitted database setting.

mceclip7.png

Find and Replace

Ctrl+F (Windows) or Command+F (Mac) will bring up the find and replace box as shown below.

 

mceclip6.png

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.