SQL statement Writing Tool (SQL _Prompt_4 plug-in)

I have been writing SQL statements for so long (for about two years). From the first time I learned it, I hope that I can give a smart prompt like, he will prompt! How nice it is! It can reduce errors and improve development efficiency. Ah... No way, the people around you think this way, it seems that everyone has not found the SQL _prompt plug-in, or they do not know this plug-in [I only know it today], everyone is expecting a smart prompt from Sqlserver2008! I was overjoyed to have this prompt function in Sqlserver2008! Of course, I will update it to SqlServer2008 now! You must know that you are not good at English, and it is painful to remember so many words! Basically, I want to be comfortable with smart reminders for all the things I have developed now! In addition, in SQL statements, for the sake of standardization, the keywords are capitalized, and some must be in lower case! The upper case and lower case letters are converted to higher headers, so the SQL statements I write are not very standard! But it won't happen in the future, because I have a magic weapon! Haha! I found that the SqlServer2008 prompt is not a complete prompt, for example

The keywords 'select' and 'from' are not displayed, but only dbo. Table names are displayed! Today in watch webcast SQL Server 2008 T-SQL programming series course (1) class, see the teacher when writing SQL intelligent prompt how good Oh! Later, he said that he used the plug-in. He must have asked Baidu about the plug-in !!

Download SQLPrompt

Installation Process:

1. The network has been disconnected first (Network disconnection --!!)

2. Shut down all SQL Server and VS and run SQLPrompt 4.0.exe for installation.

3.after installation, return redgate.sqlprompt.trayapp.exe!

4. Copy SQLPrompt 4 Keygen.exe to the installation directory, and press 1. patch to get Serial.

5. Open SQL Server Management Studio Express. Note that SQL Prompt 4. Oh year is added to the top menu bar!

6. Click SQL Prompt 4> Serial Number> Enter Serial Number and Enter Serial in step 1.

7. Next, obtain a string in the left text box, copy it to the SQLPrompt 4 Keygen.exe text box, and click 3. Gxxxx.

8. Copy the value calculated by SQLPrompt 4 Keygen.exe to SQL Prompt 4.

9. Click Finish.

The above steps originated from the Fire Network: http://www.liehuo.net/a/201003/1514240.html thanks

Copy the text generated by the Registration machine to the blank box above load from!

I have passed the above method! [It seems that there are smart prompts when you do not register]

Start an exciting journey: SQLPrompt Smart Tips

There are also many shortcut keys: formatting SQL Ctrl + K + Y

For example, the ct + tab key is used to create a table.

Are you still worried about n table fields? Directly * + tab automatically displays all fields

Of course, you can also customize more shortcut keys...

For more information about SQLPrompt, please try again after installation!

Technorati label: sqlserver, SqlPrompt