Convert SQL development tool SQLPrompt5.1 complete cracking + tutorial

The more SQL scripts you write, the less efficient you always think. This is irrelevant to the typing speed. When I write an SQL script, at least the SQL format will be arranged to be easy to read, because others will read your SQL, whether in a program or in a script file, good typography not only makes people look pleasing to the eye, but also saves time for communication with others

The more SQL scripts you write, the less efficient you always think. This is irrelevant to the typing speed. When I write an SQL script, at least the SQL format will be arranged to be easy to read, because others will read your SQL, whether in a program or in a script file, good typography not only makes people look pleasing to the eye, but also saves time for communication with others

The more SQL scripts you write, the less efficient you always think. This is irrelevant to the typing speed. When I write an SQL script, at least the SQL format will be arranged to be easy to read, because others will read your SQL, whether in a program or in a script file, hong Kong virtual host, good layout not only makes people look pleasing to the eye, but also saves time and effort to communicate with others, not because of a group of SQL to ask the Team Member: can you help me explain what such a large SQL statement does?

Although SQL intelligence prompts are provided in versions from Microsoft to SQL 2008 or later, its response is too slow. When the prompt is displayed, we can have a line of statements. In addition, it does not provide the SQL code Formatting Function. We can only manually format the SQL code by ourselves. manual formatting always takes a lot of time.

I. sqldbx tool Introduction

Before introducing SQL Prompt 5.1 (the latest official version is 5.3), we will introduce another SQL tool sqldbx.
It is also an SQL programming tool with smart prompts. It is small and flexible and supports multiple types of databases (not just SQL Server ). The only drawback is that it does not support Chinese characters. The Chinese characters found in the data table are garbled in the results of this tool.
All in all, it is also a tool that can improve the efficiency of SQL programming.

You can download it from CSDN: it is also a cracked version.

The core of this article is the SQL Prompt 5.1 cracking environment. I was discouraged when I saw the price above $900 on the official website. If it was just less than $200, I would be willing to pay for the software. Who makes it really useful?

Ii. SQL Prompt 5.11. Download SQL Prompt 5.1

:

2. Install SQL Prompt 5.1

1) After the download is complete, extract the following two items. Files in Crack are cracked files.

2) Run sqlprompt.exe until installation is complete.

SQL Prompt provides three functions. We are most concerned with SQL Prmopt 5.1 -- Write, edit and revoke e SQL effortlessly.

3) overwrite the RedGate. SQLPrompt. SSMSUI. dll and RedGate. SQLPrompt. VSUI. dll files.

Back up the two dll files before overwriting them.

4) execute the cracking command

Maybe you run Register for the first time. the bat file is the same as that of me. The pop-up command box is a flash, and you don't know what happened. You can be sure that the attack was not successful, when you open SQL Server, an SQL Prompt loading error occurs.
Open the Register. bat file in notepad and see the following code. It is obviously used to Register dll (regasm is an assembly registration tool)

% SYSTEMROOT % \ Microsoft.net \ Framework \ v2.0.50727 \ regasm "% ProgramFiles % \ Red Gate \ SQL Prompt 5 \ RedGate. SQLPrompt. SSMSUI. dll"

Since automatic registration fails, register it manually. Execute the following two commands in the command line respectively (you can also register with. NET Framework 4.0 ):

Cd C: \ Windows \ Microsoft. NET \ Framework \ v2.0.50727regasm "D: \ Program Files (x86) \ Red Gate \ SQL Prompt 5 \ RedGate. SQLPrompt. SSMSUI. dll"

The second command depends on the installation path of your SQL Prompt 5.

3. Use SQL Prompt to write SQL in SQL Server

Note: SQL Prompt also supports SQL Server 2005. My environment is SQL Server 2008 R2.

1) Smart notification

The smart prompts of SQL Prompt are very sensitive, which is much better than those of 2008 R2. When you enter keywords, even if you enter lowercase letters, it will automatically convert them to uppercase letters (in fact, all SQL keywords are capitalized in a more standard way ), you do not need to switch the Caps Lock key back when writing keywords or common words.

In addition to code smart prompts, it also provides smart prompts for table definition. You may have a large table, but you cannot remember some fields. You do not have to go to the Server resource manager on the left side of SQL Server to view the structure of the table.

2) SQL code formatting

Before formatting:

Create database TestGOUSE TestGOCREATE TABLE Employees (Id int identity primary key, EmployeeName NVARCHAR (100), EntryDate DATE) gocreate table Users (Id int identity primary key, UserName NVARCHAR (100 ), gender CHAR (1), Birhdate DATETIME, EmployeeId int) GOSELECT u. userName, e. employeeName FROM dbo. users uINNER JOIN dbo. employees e ON e. id = u. employeeId

After formatting:

Create database TestGOUSE TestGOCREATE TABLE Employees (Id int identityprimary key, EmployeeName NVARCHAR (100), EntryDate DATE) gocreate table Users (Id int identityprimary key, UserName NVARCHAR (100 ), gender CHAR (1), Birhdate DATETIME, EmployeeId INT) GOSELECT u. userName, e. employeeNameFROM dbo. users uINNER JOIN dbo. employees e ON e. id = u. employeeId

If you write a large storage process or try to format it with SQL Prompt, it will save us a lot of time.

4. Use Soruce Control in SQL Server