Free, good SQL Formatter?
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
There's a forum for these types of questions: Free Tools[^]
The difficult we do right away... ...the impossible takes slightly longer.
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
Check this page[^]. I haven't found any limitations, but then again, I haven't searched.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
Not free (bloody expensive but we get the bundle so...) but quite good in Red-Gates SQL Prompt. Integrates into the IDE and you can right click and format either a selected area or an entire script. It also requires that the script is error free which is not a bad thing!
Never underestimate the power of human stupidity RAH
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
How about just doing it right to start with???
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me
-
How about just doing it right to start with???
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me
mark merrens wrote:
How about just doing it right to start with???
exactly
Just along for the ride. "the meat from that butcher is just the dogs danglies, absolutely amazing cuts of beef." - DaveAuld (2011)
"No, that is just the earthly manifestation of the Great God Retardon." - Nagy Vilmos (2011) -
How about just doing it right to start with???
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me
Because I'm not the only one on the team. I had some stuff neatly formatted, then someone else messed with it.
-
This must have been discussed here many (many many) times, but I still don't know the solution to this. What is the free, good way of formatting SQL queries? I was using http://www.sqlinform.com[^], but it comes with some limitations, like limiting the number of lines in the script. SSMS's Tabify doesn't help. Any tool would you guys would like to suggest?
Regards, Jwalant Natvarlal Soneji
Try http://www.ssmstoolspack.com/[^] Or http://www.apexsql.com/sql_tools_refactor.aspx[^] Both are free
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
