Script And Snippet Sharing

PragmaSQL utilizes script and code snippet sharing through its own database. You can install PragmaSQL tables and stored procedures from Options menu and then you are ready to go with sharing features.

NOTE: You can download PragmaSQL database object creation script from PragmaSQL Online web site.

Shared Scripts

Shared scripts are edited with the script editor by default. You can share any T-SQL script from the script editor with your coworkers. Sure you can open shared scripts from the script editor.

You can attach help text to the shared scripts. Help text is persisted in RTF format so that you can apply any custom formatting to your help text, including inserting images.

You can defined code snippets and share these snippets with your coworkers almost in same way you define shared scripts. Shared code snippets support all features described for shared scripts.

You can invoke shared code snippets from script editor with Ctrl+J key combination.

Code completion proposal (invoked with Ctrl+J from the script editor) supports multiple snippet repositories. Shared code snippets is only one of them, you can also define local code snippets and navigate through these lists with code completion proposal dialog.

Defining Local Code Snippets

You can define local code snippets through Tools -> Options menu item by selecting Script Editor -> Code Completion Lists node in the options dialog.

Multiple code completion lists are allowed. You invoke these lists by pressing Ctrl+J in the script editor.