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

- format option, sql pretty printer, v238

## SQL Formatter Option: Subquery newline after EXISTS keyword

This format option control whether put a blank line after EXISTS keyword when there is a subquery follows. name: Subquery_Newline_After_EXISTS, default is false setting path: subquery -> Linebreak after EXISTS keyword SELECT TOP 1 CASE WHEN CASE WHEN NOT EXISTS (SELECT [lpa_l1].[Categoryid] FROM (SELECT p.[Categoryid] AS [categoryid], p.[Discontinued], p.[Unitsonorder] FROM [northwind].[dbo].[PRODUCTS] p WHERE (( p.[Categoryid] = @p1 ))) [lpa_l1]) THEN 1 ELSE 0…

- admin
- September 27, 2011

- format option, sql pretty printer, v238

## SQL Formatter Option: Subquery newline after IN keyword

This format option control whether put a blank line after IN keyword when there is a subquery follows. name: Subquery_Newline_After_IN, default is false setting path: subquery -> Linebreak after IN keyword SELECT od.[Discount], od.[Quantity], od.[Unitprice] FROM [northwind].[dbo].[ORDER DETAILS] AS od WHERE ( od.[Orderid] IN (SELECT o.[Orderid] AS [orderid] FROM [northwind].[dbo].[ORDERS] o WHERE (( o.[Customerid] IN (SELECT c.[Customerid] AS [customerid] FROM [northwind].[dbo].[CUSTOMERS] c) ))) ) After…

- admin
- September 27, 2011

- release, sql pretty printer

## New release: SQL Pretty Printer Version 3.2.7

Hi All, we have introduced some new features since version 3.2.5, Here is the list for you: Download this new release: Add-in for SSMS supports Microsoft SQL Server Management Studio 11(SQL Denali) now Add a new format…

- admin
- April 28, 2011

- 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