• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

tool to format a sql query into a proper format

is there any tool out there to automatically format your query to more easily readable format..

example

select * from a join b on id1=id2

to

SELECT *
FROM
A
JOIN
B
ON
id1=id2..

of course, i am only asking for more complicated queries..

is this out there at least in part.. i don't think ssms offers any solutions for this, not?
0
25112
Asked:
25112
3 Solutions
 
Chris LuttrellSenior Database ArchitectCommented:
I like the Red-Gate tools, i.e. SQL Prompt 5, here, you can try it for 2 weeks free and our team thinks it is well worth the price.
0
 
Pratima PharandeCommented:
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I would second the Red-Gate SQL Prompt. It is a great product.
0
 
25112Author Commented:
Super! thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now