Post reply

TSQL Formatting tool?

  • November 15, 2016 at 9:54 am

    #1912599

    Let us know if you decided for anyone.

    As Jeff, I don't like to depend on a formatting tool, but it's good to have one when dealing with code written by someone else who doesn't follow standards at all. (And I have no authority to enforce formatting standards)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 15, 2016 at 10:10 am

    #1912608

    SQL formatting tools are very useful when you have a new coding standard applied to legacy databases and applications or when there are other developers writing code outside the core DBA/database developer team. A small close knit team can agree on a coding standard, but getting everyone across a large enterprise on the same page is near impossible.

    Also, if executive management (or the client) likes to count lines of code as a measure of programmer productivity, then an auto-formatting tool allows you to milk it for all it's worth with a minimal amount of actual effort. That mediocre 100 line stored procedure you spent all week crafting may function according to spec and look like a work of art to you, but it can potentially be stretched out to an even more impre$$ive 500 or 1000 lines. :rolleyes:

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply