How to format a query

Question

How to format a query

spectra

SSCarpal Tunnel

Points: 4120
More actions
March 21, 2014 at 7:13 am

#289621

How to format a query in Microsoft SQL Server Management Studio 2008 R2.
I dont see any format query kind of menu.
Is there any way ?
I have a query which is one line ...I find it difficult to read.
I want to format it in a structured way ....better readability

Viewing 11 posts - 1 through 10 (of 10 total)

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

Are you talking about changing the font and the background colour, etc? If so take a look at Tools > Options > Fonts and Colors.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

Are you talking about changing the font and the background colour, etc? If so take a look at Tools > Options > Fonts and Colors.

djj SSCoach Points: 18831 More actions · Answer 3

SSMS does not format queries or their results. You need to format the query manually.

You should use something like .NET to get and format the results.

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Are you lookin for following link?

http://sql-format.com/

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 5

spectra

SSCarpal Tunnel

Points: 4120

March 21, 2014 at 7:36 am

#1699085

I want to format sql query.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 6

You need to tell us what you mean by that because it's not clear.

djj SSCoach Points: 18831 More actions · Answer 7

If you have T-SQL code you want formated, show use the code.

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 8

>>>>http://sql-format.com/

yes. This is what I need.

thanks

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

Another option is to use http://poorsql.com

It has SSMS and notepad++ plugins plus, plus a stand-alone formatter.

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

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 10

If you don't mind spending a little money, Red Gate SQL Prompt[/url] is a tool that I can't live without. It formats your code. And it provides code completion way above and beyond that available in SSMS, plus code snippets, tab history, all kinds of joy.

DISCLAIMER: I gleefully work for Red Gate.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning