SQL Small Helper--sql Prompt

background:

When the database design is relatively complex, large, if we are not very familiar with the script, it will be difficult to complete seemingly simple increase, delete, change, check the operation. We need a software to give the appropriate tips or help to improve the readability of the code, faster and better to complete the task.

Introduction:

SQL prompt is a plug-in that accomplishes this, and it's a SQL Server and VS plug-in that has the SQL Smart Tip feature. SQL prompt can be retrieved automatically based on the object name, syntax, and user-written code snippets of the database, intelligently providing the user with the only appropriate code choice.

function:

1) Smart Tips

Hint Table name

SQL prompt looks for a matching table name based on the database entered by the user for the user to select.

Prompt script

When the user selects a table name, SQL prompt displays its script scripts.

Hint table structure

After selecting a table, the table structure and the corresponding data type are given in addition to the script for the table.

2) SQL Help

For example: When writing the INSERT statement, enter INSERT INTOdbo. Apartment"And then enter, the SQL prompt will automatically be fully replenished.

3) Quick Output

In SQL prompt, features like shortcut keys are provided. Enter a few letters and hit the ENTER key and it will be recognized automatically.

Here are a few examples:

SSF-----------SELECT * FROM

DF-----------DELETE from

At-----------ALTER TABLE

af----------- ALTER FUNCTION

4) SQL Formatting

Basic settings:

Open VS, click SQL Prompt 5,—— Options in the menu to make major settings changes.

Note: Do not remove the Disable Code suggestions before the check.

Summary:

When we initially did not understand the structure of the table, we needed to use SQL prompt as a convenient and no-brain tool to help us accomplish our task. However, we can not rely entirely on it, or to analyze, understand the table design and its principles. Only in this way can we achieve better development and maintenance.

SQL Small Helper--sql Prompt