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…
There are lots of improvements since V0.4, below are some of the most important improvements: Oracle SQL and PLSQL query parse tree structure was fully accessible. toString() of all parse tree node classes was supported, so you can get text of parse…
In this version, we can easily fetch table and column from stored procedures(packages) of Oracle and SQL Server. Let’s take this create trigger statement(Oracle) for example: CREATE TRIGGER hr.emp_permit_changes BEFORE DELETE OR INSERT OR UPDATE ON hr.employees BEGIN INSERT INTO…
Hello everyone! We have some improvements about this new update. SQL Server merge statement was supported. Html output was checked as XHTML 1.0 Strict. Support qualified name of pivot column. Qualified data type was supported in SQL Server. When convert…
