Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# admin

- Joined: November 19, 2009
- Articles: 40

- release, sql pretty printer

## New release: SQL Pretty Printer Version 3.2.5

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…

- admin
- February 17, 2011

- sql pretty printer

## Customize toolbar of SQL Pretty Printer Add-In in Visual Studio

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…

- admin
- December 7, 2010

- release, sql pretty printer

## New release: SQL Pretty Printer Version 3.2.0

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…

- admin
- December 1, 2010

- sql pretty printer

## SQL Refactor: rename column and table

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…

- admin
- November 29, 2010
- 1 Comment

- release, sql pretty printer

## New SQL format options in Ver3.2.0

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,…

- admin
- November 29, 2010
- 1 Comment

- reference, sql

## SQL Reference(reserved keyword)

SQL Server 2008: Oracle 10g release 2 MySQL 5.0 DB2 V9.7 Microsoft Office Access

- admin
- November 14, 2010

- sql, translation

## Datatypes translation between Oracle and SQL Server part 2: number

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…

- admin
- August 2, 2010

- reference, sql, translation

## Datatypes translation between Oracle and SQL Server part 1: character, binary strings

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…

- admin
- July 28, 2010

- reference, sql

## Correlation names and Column name qualifiers in correlated references

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…

- admin
- December 17, 2009

- reference, sql

## How to find out datbase version using SQL query

DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;

- admin
- December 10, 2009