|
SQL Prompt is a SQL Server and VS plugin with SQL smart prompt function. SQL Prompt automatically retrieves database object names, syntax, and user-written code snippets, intelligently providing users with unique code options. Automatic script settings provide users with simple code readability - this is especially useful when developers are using scripts that are not very familiar Sql Prompt smart prompts and their formatting are very easy to use. Free download address:http://www.jb51.net/database/201355.html 1. Download SQL Prompt 5.3.4.1, which is a compressed package with three files inside No login and no points download address:http://www.jb51.net/database/201355.html 1) After the download is completed, unzip to get the following three items. One is the registration tutorial doc, the other is the keygen keygen, and the other is the official original installation package V5.3.4.1. 2. Install SQL Prompt 5.3.4.1 1) Run SQLPrompt_5.3.4.1.exe, all the way to Next until the installation is completed. SQL Prompt offers three features, and the one we care about the most is SQL Prmopt 5.3.4.1 - Write, edit and explore SQL effortlessly 2) Open SQL Server 2008 R2 and click SQL Prompt 5 in the toolbar 3) Open SQL.Prompt.Keygen.5.3.exe and copy the serial number to the window just now 4) Then click Activate, pay attention to disconnecting the network first, wait for a while to get a network error, and then click Activate Manually (offline registration) 5) Copy the code into the text box in the middle of the keygen, and the corresponding code will be generated 6) Copy the generated code into the text box on the right, then click Finish 7) Successfully cracked!! 3. Use SQL Prompt to assist in writing sql in SQL Server Note: SQL Prompt also supports SQL Server 2005, and my environment is SQL Server 2008 R2. 1) Smart prompts SQL Prompt's intelligent prompts are very responsive, much better than what comes with 2008 R2. When entering keywords, even if you type lowercase, it will automatically convert them to uppercase for you (in fact, all SQL keywords are capitalized in a more standardized way), so you don't need to switch the Caps Lock key back and forth when writing keywords and normal words. In addition to code smart hints, it also provides table definition smart hints. Maybe you have a large table, but there are fields that you can't remember clearly, and you don't have to go to Server Explorer on the left side of SQL Server to see the structure of the table.
|