如果您經常遇到下述的情形,本套軟體將是您最佳的解決方案:
- 經常閱讀別人編寫的SQL代碼。
- 經常分發自己編寫的SQL代碼給別人。
- 需要格式化、規範大量的SQL檔。
- 統一公司或開發團隊的SQL代碼書寫格式。
在程式設計語言中訪問資料庫時需要嵌入SQL,同時又經常從程式設計語言中提取SQL,然後到資料庫工具中進行調試。
SQL 格式化工具以一種結構統整的方式表達SQL語言,其可以精編結構,並大寫關鍵字。是一款用來説明資料庫管理員,開發人員格式化SQL語句,提高SQL語句的可讀性。支援輸出各種語言格式...如:HTML,VB,Java ……等多種語言。並且支援CMD命令操作其他程式調用更加方便... SQL Pretty Printer可以讓每個人員開發時使用自己喜歡的格式,但遞交代碼時,統一用公司制定的SQL規範。SQL Pretty Printer可以讓你輕鬆的在SQL和各種程式設計語言(保括但不限於C#、Java、VB、 Delphi、 PHP)中轉換。
Get your favorite layout
With more than 80 format options and still growing, get your favorite SQL layout, It's never been so easy. switch between different styles with predefined layout templates quickly.
Efficient and standard
Allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.
Don't reinvent the wheel
Don't waste time to write an “SQL formatter” feature yourself, It's already here for your .NET application and any COM enabled programming language such as VB, VC!
Focus on functionality
Just write SQL and focus on functionality, don't worry about how many spaces or tabs need to be used to indent SQL. SQL Pretty Printer will do it for you with just one hotkey. (short video)
Fantastic time saver
Debugging SQL in C#, VB.NET, ASP.NET or any Java program is an extremely time consuming job. Quickly converting between SQL and different programming languages is now made very easy.
Be professional
Publish well formatted and colored SQL scripts (in html or RTF) on the web, blogs, forums, articles or books. It will make you look more professional.
Comparison between V3.x and V2.x
Features
|
V3.x
|
V2.x
|
Format Options
|
More than 60, still growing
|
20
|
switch between different format option files
|
Y
|
N
|
Performance
|
1.5-2 times faster
|
-
|
APIs
|
Y
|
N
|
Command line
|
Better support
|
Y
|
Preserve layout of selected SQL code block
|
Y
|
N
|
Remove comment
|
Y
|
N
|
Show line number
|
Y
|
N
|
Html output
|
Y
|
Y
|
RTF output
|
Y
|
Y
|
Syntax highlighting
|
Configurable
|
N
|
syntax error
|
output (partially support)
|
No output
|
Desktop version
Beautify SQL in editors such as notepad or UltraEditor with one key press.
Never waste a minute
SQL Pretty Printer Desktop Version allows you to format your SQL wherever you are regardless of your Internet connection. It generates various output formats, including text, colorful html (Used in web, blog, wiki, forums) and RTF.
Batch mode enables you to clean up SQL in multifiles under a nested directory.
While sitting in the tray, you can format SQL in any editor like Microsoft Query Analyzer, UltraEditor or notepad with just one hotkey.
Get your favorite layout
With more than 80 format options and still growing, get your favorite SQL layout, It's never been so easy. switch between different styles with predefined layout templates quickly.
Efficient and standard
Allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.
Focus on functionality
Just write SQL and focus on functionality, don't worry about how many spaces or tabs need to be used to indent SQL. SQL Pretty Printer will do it for you with just one hotkey.
Be professional
Publish well formatted and colored SQL scripts (in html or RTF) on the web, blogs, forums, articles or books. It will make you look more professional.
Add-In for SSMS
Tidy SQL inside SQL Server Management Studio on the fly.
Streamlined integration
Add the ability to format SQL inside SQL Server Management Studio with SQL Pretty Printer Add-In for SSMS. It makes your team more productive by using a uniform layout rule and standardize SQL in your team.
Just click on "Format Selected SQL" or "Format All SQL", the Add-In will beautify SQL according to your predefined layout rules.
Get your favorite layout
With more than 80 format options and still growing, get your favorite SQL layout, It's never been so easy. switch between different styles with predefined layout templates quickly.
Efficient and standard
Allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.
Be professional
Publish well formatted and colored SQL scripts (in html or RTF) on the web, blogs, forums, articles or books. It will make you look more professional.
Focus on functionality
Just write SQL and focus on functionality, don't worry about how many spaces or tabs need to be used to indent SQL. SQL Pretty Printer will do it for you with just one hotkey.
Add-In for Visual Studio
Besides being able to beautify SQL, you can also convert SQL to C#, VB and vice versa quickly in VS.
Streamlined integration
Add the ability to format SQL inside Visual Studio with SQL Pretty Printer Add-In for VS. It makes your team more productive by using a uniform layout rule and standardize SQL in your team.
Just click on "Format Selected SQL" or "Format All SQL", the Add-In will beautify SQL according to your predefined layout rules.
Quickly converting between SQL and C#, VB.NET and vice verser, this will dramatically save your time while debugging SQL in C# or VB.NET program.
Get your favorite layout
With more than 80 format options and still growing, get your favorite SQL layout, It's never been so easy. switch between different styles with predefined layout templates quickly.
Efficient and standard
Allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.
Be professional
Publish well formatted and colored SQL scripts (in html or RTF) on the web, blogs, forums, articles or books. It will make you look more professional.
Focus on functionality
Just write SQL and focus on functionality, don't worry about how many spaces or tabs need to be used to indent SQL. SQL Pretty Printer will do it for you with just one hotkey.
SQL Pretty Printer Desktop Version
Windows XP/2000/Vista/Win7-10
SQL Pretty Printer Add-In for SSMS
SQL Server Management Studio 2005/2008/2012/2014/2016, Express Edition
SQL Pretty Printer Add-In for VS
Visual Studio 2005/2008/2010/2012/2013