TSQL Formatting tool?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  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

• Eric M Russell

  SSC Guru

  Points: 125595

  More actions

  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