Very often, I need to split a long SQL statement into a few line for easier
reading.
Is there a function, store procedure or third party tool can do this job?
Using it, I can pass a long SQL statement as one string, setup the lenth of
line and will get a readable SQL statement.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2009...

Hi aspfun,

Maybe this site helps: http://www.sqlinform.com/

(And then choose the "try it online" option).

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

SQL Prompt from Red-Gate.com is an awesome tool for reformatting your
SQL to make it more readable.  It adds intellisense functionality to
SQL Server 2000 and 2005 (2008 has it built-in) as well as the
reformatting options.  The reformatting is a huge reason why we use
it, so that all our SQL from all our developers uses a similar format
and each developer gets used to the standardized format.

Well formatted SQL is much easier to read, debug, and maintain and
there isn't anything built into SSMS to help with this.

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

-Eric Isaacs