Hi All, we have introduced some new features since verion 3.2.0, Here is the list for you: Download links: Desktop Version: Add-In for SQL Server Management Studio: Add-In for Visual Studio: New format options: Remove redundant brackets…
After install SQL Pretty Printer Add-On for Visual Studio, toolbar of SQL Pretty Printer sometimes doesn’t appear in IDE like this: You can “Tools->Customized”, finding the buttons under the “Add In” category” mixed in with buttons for all the other…
In this new version, we have introduced some awesome new features, and make it more easy to use by redesign format option panel. This version had better support for New T-SQL features introduced in SQL Server 2008. Download SQL Pretty…
We begin to introduce features of SQL Refactor since Version 3.2.0. The first feature we added in Version3.2.0 is rename column and table of SQL script. SQL Pretty Printer is able to rename column and table in complex SQL including…
We have introduced 9 new format options in SQL Pretty Printer version 3.2.0. 1. IntoClauseInNewline when IntoClauseInNewline is false when IntoClauseInNewline is true 2. WhereClauseInNewline, LinefeedsAndOr_option when WhereClauseInNewline is false when WhereClauseInNewline is true position of AND/OR keyword and newline,…
SQL Server 2008: Oracle 10g release 2 MySQL 5.0 DB2 V9.7 Microsoft Office Access
This is an article in the series that we talking about translate SQL query among different databases. This article focus on the translation of number datatype between oracle and SQL Server database. The main difference of number datatype between oracle…
Datatypes translation is one of the most important things you need to consider when migrate your application from one database to the other. This is one of the series of articles that we talking about translate SQL query among different…
A correlation name can be defined in the from clause of a query and in the first clause of an update or delete statement. for example, the clause FROM X.MYTABLE Z establishes Z as a correlation name for X.MYTABLE. With…
DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;
