T-SQL formatting tool

Question

T-SQL formatting tool

Viewing 10 posts - 16 through 24 (of 24 total)

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

well you could always do it online at http://poorsql.com/...maybe a few more key strokes ( cut and paste ) but if its important what the heck 🙂

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 2

Thanks, it's not the end of the world. It was just a really handy feature that I'd gotten used to and was hoping that there was another product out that that did a similar job for SSMS 2016.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

J Livingston SQL (7/26/2016)
well you could always do it online at http://poorsql.com/...maybe a few more key strokes ( cut and paste ) but if its important what the heck 🙂

I preferred to use the Winforms app to avoid sending queries through the network.

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: 125561 More actions · Answer 4

Auto formatted code can look a bit dry. If you think it's worth spending a little money on genuine hand crafted SQL formatting (with all the little ticks and imperfections intact) but you don't have the time, then you can offload the task to Amazon's Mechanical Turk service. They'll even add comments, fix bugs, or finish off work in progress. There is a web service and .NET api for submitting work units, so you could develop a SSMS add-in as well.

https://requester.mturk.com/tour/data_cleansing

http://blog.stevex.net/mechanical-turk-visual-studio-edition/

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

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 5

dbafromthecold@gmail.com

SSChampion

Points: 10160

July 27, 2016 at 2:29 am

#1892203

Nice thanks for that. Will be checking that out!

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 6

+1 SQL Prompt

It would be pricey if it were only providing code formatting but it is much much more than that. It is worth every penny in my opinion.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 7

Indeed, I use SQL Prompt on a daily basis. Very handy tool.

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 8

SSMSBoost has a version that's compatible with SSMS 2016 with a formatter that can handle RESTORE statements.

http://www.ssmsboost.com/social/posts/m12238-SSMSBoost-v3-0-Beta--2008-2012-2014

It works so much better than any of the paid options that I've seen (looking at you ApexSQL)

fomenkov1986 Grasshopper Points: 11 More actions · Answer 9

Thanks for the information! I want to add one more tool to this list - I use SQL Formatter to make my code better. This is an online service Online SQL Formatter

Jonathan AC Roberts SSCoach Points: 18355 More actions · Answer 10

There is a free SQL formatting tool from Apex, probably not as good as Redgate's, but you can configure the formatting quite extensivley.
https://www.apexsql.com/sql_tools_refactor.aspx