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

Category sql pretty printer

sql pretty printer

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…

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

SQL formatter Web Service

We are pleased to let you know that  SQL formatter web service is available now. This is another chooice for you to use our SQL formatter, Besides using  free online version at , you can use this SQL formatter…