Home Forums SQL Server 2008 SQL Server 2008 - General Another free T-SQL Formatter, open-source and SQL2K8-compatible, SSMS Add-In RE: Another free T-SQL Formatter, open-source and SQL2K8-compatible, SSMS Add-In

  • September 20, 2011 at 2:29 pm

    #1384159

    Tao Klerks (9/20/2011)

    #4: Removing most of those newlines is just a question of unchecking the "Expand Comma Lists" option; the one that you won't be able to remove is the one just before OPTION - I'm always breaking the OPTION clause out. You're saying that you'd like the whole thing to appear on a single line?? Or am I misunderstanding something?

    Sorry, I meant "WITH", not OPTION - was looking in the wrong place (and yes, I also always break on OPTION); so, I always break on ddl WITH clauses - but I guess I could make an option for that if it made sense 🙂

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.