Implement SQL intelliisense and auto-fill SQL code-reprint

Source: Internet
Author: User
Tags sql server management sql server management studio

Today I'm going to introduce you to SQL Assistant, a free tool for adding intelliisense to T-SQL and PL/SQL.

To implement SQL intelliisense, simply put, the SQL code is automatically filled. With this, it is very convenient to write code.

The tool is built in to DB tools for Oracle, MS Enterprise Manager, ms SQL Server Management studio, ms SQL Server Management studio Express, MS query analyzer, vs 2003, VS 2005, supports notepad and SQL plus W. Since this tool implements the SQL intellisense function through plug-ins, it theoretically supports n multi-editor. I will introduce you to how to configure SQL assistant to add the SQL intellisense function to the tablet.

SQL Assistant Official Website: http://www.softtreetech.com/isql.htm

The following is a demo of some SQL asistant functions:

SQL query analyzer example

SQL * Plus example

Now I will introduce how to configure SQL assistant to add the SQL intellisense function to the WordPad:

First, open the WordPad program and place the cursor in the text editing area.

Then, open SQL assistant and press Ctrl + F5. A dialog box is displayed. Click OK after setting SQL compliance, SQL renference, and code snippets.

After completing the preceding steps, you have added the SQL intellisense function to the WordPad program. If you want to modify the settings later (for example, if you want the WordPad program to support PL/SQL intelliisense), press Ctrl + F5. the dialog box will pop up again. Modify the settings and save the settings.

The text above only serves as an example. You can add the SQL intellisense function to your favorite text editor.

P.s: I tested it briefly. Programs Written in Java do not support SQL assistant, and emeditor does not. Other editors are not tested. In general, the SQL assistant function is good and supports most commonly used editors, but the stability is not very good. Sometimes the editor is suspended or suddenly closed during use. However, SQL assistant is currently only a beta version, and we believe that the stability of later versions will be improved.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.