• "Which SQL formatter for VS Code?"

    What are the key features and functionalities of the Visual Studio Code (VS Code) extension designed for SQL formatting, particularly emphasizing its configurable formatting options, and how does it enhance the overall user experience when working with…

  • ApexSQL Formatter fails to format code with UNION

    ApexSQL Formatter fails to format SPs with UNION: when running formatting on long stored procedures (> 800 lines), getting the error "Line 456, Column:0, Position:0, Incorrect syntax near 'Union' ". The same stored procedure compiles a…

  • Bookmarks are removed when running refactor

    When I have some TSQL code refactored/reformatted, all of my bookmarks are removed. Are there any workarounds to this? 

  • How to format a file with the encoding (Shift_JIS.. etc) from CLI

    I was impressed with the fine-grained nature of the file format settings, but it didn't work as expected in my language (Japanese) when running from the command line.

    I had my encoding converted from shift_jis to utf-8.

    do you know how to format…

  • ApexSQL Refactor: Leading Commas for Column Lists

    I'm using ApexSQL Refactor to format my SQL within Visual Studio and SSMS and I've almost got it configured the way I want it with a few exceptions.

    How do I get leading commas to line up with the SELECT keyword rather than putting the comma in…