SQL programming tools SQL prompt download and installation cracked graphics and text tutorial _mssql

SQL prompt smart hints and their formatting is easy to use.

Free Download Address: http://www.jb51.net/database/201355.html

1. Download SQL Prompt 5.3.4.1, is a compressed package, which has three files

No-sign-in-free points download address: http://www.jb51.net/database/201355.html

1 after the download is complete, the following three items are extracted. One is the registered tutorial doc, one is the registration machine 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 we are most concerned with SQL Prmopt 5.3.4.1--write, edit and explore SQL effortlessly

2 Open SQL Server 2008 R2 in the toolbar click SQL Prompt 5

3 Open Sql.prompt.keygen.5.3.exe and copy serial number to just the window

4 then click Activate, notice to break the net first, wait for a while will prompt the network error, then click Activate manually (offline registration)

5 Copy the code into the middle of the register in the text box will generate the corresponding code

6) then copy the generated code to the text box on the right, and click Finish

7) cracked success!!

3. SQL prompt in SQL Server to assist in writing SQL

Note: SQL prompt also supports SQL Server 2005, and my own environment is SQL Server 2008 R2.

1) Smart Tips

The smart tips for SQL prompt are very sensitive, much better than the 2008 R2 themselves. When you enter a keyword, even if you enter lowercase, it will automatically convert you to uppercase (in fact all of the SQL keyword is a more canonical writing), do not need to write keywords and ordinary words back and forth switch caps LOCK key.

In addition to code intelligence hints, it also provides a table definition smart hint. Maybe you have a big table, but some fields you can't remember clearly, you don't have to go to the Server Explorer on the left of SQL Server to view the structure of this table.

2) SQL code formatting

Before formatting:

 Create DATABASE Test
 go
 with test
 go
 
 create TABLE Employees
 (
 Id INT IDENTITY PRIMARY KEY,
 EmployeeName NVARCHAR (MB),
 entrydate DATE
 )
 
 go
 
 CREATE TABLE Users
 (
 Id INT IDENTITY PRIMARY KEY,
 UserName NVARCHAR (MB),
 Gender CHAR (1),
 birhdate DATETIME,
 EmployeeId int
 )
 Go
 
 
 SELECT u.username, e.employeename from dbo. The Users u
 INNER JOIN dbo. Employees e on e.id = U.employeeid

After formatting:

 Create DATABASE Test
 go
 with test
 go
 
 create TABLE Employees
   (
    Id INT IDENTITY
       PRIMARY KEY, C8/>employeename NVARCHAR (MB),
    entrydate DATE
   )
 
 go
 
 CREATE TABLE Users
   (
    Id INT IDENTITY
       PRIMARY KEY,
    UserName NVARCHAR (MB),
    Gender CHAR (1),
    birhdate DATETIME,
    EmployeeId INT
   )
 go

 SELECT u.username,
     e.employeename
 from  dbo. The Users u
     INNER JOIN dbo. Employees e on e.id = U.employeeid

If you write a large segment of stored procedures or try to format with SQL prompt, you can save us a lot of time.

if your SQL is version 2012, this tool does not support formatting, you can download the patch directly installed on the line, the installation will automatically shut down the database, so be sure to keep good data: Patch connection: Http://download.red-gate.com/EAP/SQLPrompt64Beta/SQLPrompt64Beta.zip