SQL prompt can only prompt and its formatting is very convenient to use: Recommended URL: www.4-yecao.com
Free: http://download.csdn.net/detail/caizz520/4557385
1. Download SQL Prompt 5.3.4.1, a compressed package with three files in it
Free sign-in points: http://download.csdn.net/detail/caizz520/4557385
1) After the download is complete, unzip to get the following three items. One is registered tutorial doc, one is keygen keygen, one 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 next until the installation is complete.
SQL prompt provides three features, and what we care about most is SQL prmopt 5.3.4.1-Write, Edit and explore SQL effortlessly
2) Open SQL Server R2 on the toolbar, click SQL Prompt 5
3) Open the Sql.prompt.keygen.5.3.exe and copy the serial number to the window just now
4) Then click Activate, notice to break the network first, wait for a network error will be prompted, and then click Activate manually (offline registration)
5) Copy the code into the text box in the middle of the register to generate the corresponding code
6) Copy the generated code to the text box on the right and click Finish
7) Crack success!!
3. SQL prompt-assisted writing SQL in SQL Server
Note: SQL prompt also supports SQL Server 2005, and my own environment is SQL Server R2.
1) Smart Tips
The smart tips for SQL prompt are very sensitive, much better than the R2 comes with. When entering a keyword, even if you enter lowercase, it will automatically convert you to uppercase (in fact all SQL keyword capitalization is a more canonical way of writing), do not need to write the keyword and the normal word back and forth to switch the CAPS LOCK key.
In addition to the Code intelligence hints, it also provides smart hints for table definitions. Maybe you have a big table, but some fields you can't remember clearly, you don't have to go to Server Explorer on the left side of SQL Server to see the table structure.
2) SQL code formatting
Before formatting:
1CREATEDATABASETest2GO3UseTest4GO56CREATETABLEEmployees7(8 IdIntIDENTITYPRIMARYKEY,9 EmployeeNameNVARCHAR (100),10EntryDate DATE11)1213GO1415CREATETABLEUsers16(IdIntIDENTITYPRIMARYKEY,UserNameNVARCHAR (100),GenderCHAR (1datetime,int22 23 go24 25 26 select u.username, e.employeename from dbo. Users u27 inner join dbo . Employees e on e.id = U.employeeid
after formatting:
1CREATEDATABASETest2GO3UseTest4GO56CREATETABLEEmployees7(8 IdIntIDENTITY9PRIMARYKEY,Ten EmployeeNameNVARCHAR (100) ,11EntryDate DATE12)1314GO1516CREATETABLEUsers17(IdIntIDENTITY19PRIMARYKEY,UserNameNVARCHAR (100) ,GenderCHAR (1) ,BirhdateDatetime23 EmployeeId int< Span style= "color: #008080;" >24 ) 25 go26 27 28 select U.username, 29 E.employeename30 from dbo. Users u31 inner join dbo . Employees e on e.id = U.employeeid
If you write a large segment of stored procedures or try, using SQL prompt formatting can save us a lot of time.
If your SQL is version 2012, this tool does not support formatting features, you can download the patch directly installed on the line, the installation will automatically shut down the database, so be sure to save the good data: Patch connection:/http Download.red-gate.com/eap/sqlprompt64beta/sqlprompt64beta.zip