Solved

Fomatting a Query

Posted on 2008-10-03
1
186 Views
Last Modified: 2012-05-05
Im using SQL Server Management Studio 2005 to develop queries.

When I develop queries I usually forget to fomat them and lay them out properly so they are readable.

Are there any tools in Studio 2005 that will format the queries and lay them out automatically or is there a website out  there that shows how a query should be layed out

Thanks
0
Comment
Question by:halifaxman
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
Comment Utility
nothing native to sql server or ssms, but you can try out a product from red-gate that does wonders for this sort of thing...its called SQL Refactor.

http://www.red-gate.com/products/SQL_Refactor/index.htm
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now