SQL assistant-SQL Prompt and SQL assistant prompt

SQL assistant-SQL Prompt and SQL assistant prompt
Background:

When the database design is complex and huge, if we are not very familiar with the script, it will be difficult to complete seemingly simple addition, deletion, modification, and query operations. We need a software to provide corresponding prompts or help to improve code readability and accomplish tasks faster and better.

Introduction:

SQL Prompt is a plug-in that completes such a function. It is an SQL Server and VS plug-in with the SQL smart Prompt function. SQL Prompt can be automatically searched based on the database object name, syntax, and user-written code segments. It intelligently provides users with the unique and appropriate code selection.

Purpose:

1) Smart notification

Prompt table name

SQL Prompt searches for matched table names based on the database you enter for the user to choose from.

Script prompt

After you select a table name, SQL Prompt displays its Script.

Prompt table structure

After the table is selected, in addition to the script for the table, the table structure and corresponding data type of the table are also given.

2) SQL help

For example, when writing an INSERT statement, enter "insert into dbo. Apartment" and press Enter. The SQL Prompt is automatically complete.

3) Quick output

SQL Prompt provides functions similar to shortcut keys. Enter a few letters and press the Enter key to automatically recognize the input.

The following are examples:

Ssf ----------- SELECT * FROM

Df ----------- DELETE FROM

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

Af ----------- ALTER FUNCTION

4) SQL formatting

Basic settings:

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

Note: Do not remove the check mark before Disable Code Suggestions.

Summary:

When we first had a poor understanding of the table structure, we needed SQL Prompt, a convenient and easy-to-use tool, to help us complete the task. However, we cannot rely on it completely. We still need to analyze and understand the table design and its principles. Only in this way can we achieve better development and maintenance.