refactored SQL by shEngine

Sample (version 1.0 beta)

Before SELECT testcolumn1,CASE testcolumn1 WHEN x THEN 'c' WHEN b THEN 'd, select' END [result1], testcolumn2, [testanothercolumn,select] AS testcolum,p.testcolumn3 - p.testcolumn4 + 7 * LOG(testcolumn8 / 100.) + 5 AS result, testcolumn10, testcolumn11, ISNULL(character_maximum_length, 0) AS char_max_length, ( --sample comment 1 indent
SELECT TOP 1 oldtestcolumn1, oldtestcolumn2 FROM test.testtable, ( SELECT column1.select_table, column2.select_table FROM select_table WHERE a = b AND c = d ) ORDER BY 1 ) AS a, ISNULL(testcolumn, 0) AS anotherrtest /*sample comment 2*/, test.testcolumn13, test.testcolumn15 FROM test RIGHT JOIN test2 ON test.column1 = test2.column2 WHERE testcolumn1=2 AND testcolumn2<COALESCE(testcolumn1, 3) ORDER BY testcolumn1, [result1]After /* Formatted by REFSQL engine on sqlhere.com in 30,1152ms */
SELECT    testcolumn1,
          CASE testcolumn1
               WHEN x THEN 'c'
               WHEN b THEN 'd, select'
          END [result1],
          testcolumn2,
          [testanothercolumn,select] AS testcolum,
          p.testcolumn3 - p.testcolumn4 + 7 * LOG(testcolumn8 / 100.) + 5 AS result,
          testcolumn10,
          testcolumn11,
          ISNULL(character_maximum_length, 0) AS char_max_length,
          ( --sample comment 1 indent
          SELECT    TOP 1 oldtestcolumn1,
                    oldtestcolumn2
          FROM      test.testtable,
                    (
                    SELECT    column1.select_table,
                              column2.select_table
                    FROM      select_table
                    WHERE     a = b
                              AND c = d )
          ORDER BY  1 ) AS a,
          ISNULL(testcolumn, 0) AS anotherrtest /*sample comment 2*/,
          test.testcolumn13,
          test.testcolumn15
FROM      test RIGHT JOIN test2
          ON test.column1 = test2.column2
WHERE     testcolumn1=2
          AND testcolumn2 < COALESCE(testcolumn1, 3)
ORDER BY  testcolumn1,
          [result1]

Sample (version 0.8 beta)

Before /* MSSQL 2000 Get information from systables */ SELECT sysobjects.name, ordinal_position, column_name, data_type, ISNULL(character_maximum_length, 0) AS char_max_length, ( --sample indent select top 1 VIEW_CATALOG,VIEW_SCHEMA from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE order by 1 ) as a, ISNULL(numeric_precision, 0) AS numeric_precision,sysobjects.xtype ,syscomments.text FROM INFORMATION_SCHEMA.columns right join sysobjects on INFORMATION_SCHEMA.columns.table_name = sysobjects.name left join syscomments on sysobjects.id = syscomments.id ORDER BY table_name, ordinal_position After /* Formated by REFSQL engine on sqlhere.com in 150,216ms */
         /* MSSQL 2000 GET INFORMATION FROM SYSTABLES */
SELECT   SYSOBJECTS.NAME, 
         ORDINAL_POSITION, 
         COLUMN_NAME, 
         DATA_TYPE, 
         ISNULL(CHARACTER_MAXIMUM_LENGTH,  0) AS CHAR_MAX_LENGTH, 
         ( --SAMPLE INDENT 
         SELECT   TOP 1 VIEW_CATALOG, 
                  VIEW_SCHEMA
         FROM     INFORMATION_SCHEMA.VIEW_COLUMN_USAGE
         ORDER BY 1 ) AS A, 
         ISNULL(NUMERIC_PRECISION,  0) AS NUMERIC_PRECISION, 
         SYSOBJECTS.XTYPE, 
         SYSCOMMENTS.TEXT
FROM     INFORMATION_SCHEMA.COLUMNS
         RIGHT JOIN SYSOBJECTS
         ON INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = SYSOBJECTS.NAME
         LEFT JOIN SYSCOMMENTS
         ON SYSOBJECTS.ID = SYSCOMMENTS.ID
ORDER BY TABLE_NAME, 
         ORDINAL_POSITION 

Sample (version 0.7 beta)

Before /* MSSQL 2000 Get information from systables */ SELECT sysobjects.name, ordinal_position, column_name, data_type, ISNULL(character_maximum_length, 0) AS char_max_length, ( --sample indent select top 1 VIEW_CATALOG,VIEW_SCHEMA from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE order by 1 ) as a, ISNULL(numeric_precision, 0) AS numeric_precision,sysobjects.xtype ,syscomments.text FROM INFORMATION_SCHEMA.columns right join sysobjects on INFORMATION_SCHEMA.columns.table_name = sysobjects.name left join syscomments on sysobjects.id = syscomments.id ORDER BY table_name, ordinal_position After /* Formated by REFSQL engine on sqlhere.com in 150.625ms */
         /* MSSQL 2000 GET INFORMATION FROM SYSTABLES */
SELECT   SYSOBJECTS.NAME, 
         ORDINAL_POSITION, 
         COLUMN_NAME, 
         DATA_TYPE, 
         ISNULL(CHARACTER_MAXIMUM_LENGTH,  0) AS CHAR_MAX_LENGTH, 
         ( --SAMPLE INDENT
         SELECT   TOP 1 VIEW_CATALOG, 
                  VIEW_SCHEMA
         FROM     INFORMATION_SCHEMA.VIEW_COLUMN_USAGE
         ORDER BY 1 ) AS A, 
         ISNULL(NUMERIC_PRECISION,  0) AS NUMERIC_PRECISION, 
         SYSOBJECTS.XTYPE, 
         SYSCOMMENTS.TEXT
FROM     INFORMATION_SCHEMA.COLUMNS
         RIGHT JOIN SYSOBJECTS
         ON INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = SYSOBJECTS.NAME
         LEFT JOIN SYSCOMMENTS
         ON SYSOBJECTS.ID = SYSCOMMENTS.ID
ORDER BY TABLE_NAME, 
         ORDINAL_POSITION