Re: newbie SQL question

This makes it easier:

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

Cheers,
Jason Lepack

On Feb 26, 5:49 pm, Victoria <Victo...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
i'm working at learning how to design queries using SQL. Based on what I've
seen in this group, the SQL is much easier to follow and understand when
properly aligned (for example, with a subquery's Select, From, Where, and
OrderBy all lined up vertically) I know that Access ignores spaces and new
lines in SQL statements, but I'd like to be able to reopen the query window
without the formatting being changed. Is there a solution? (it would also
make it easier for pasting SQL to this newsgroup)


.

Relevant Pages

  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... are things called RESERVED WORDS. ... by virtually any programmer I know. ... *formatting* said query so you could break it down and isolate the problem. ...
    (comp.lang.php)
  • Re: Set based solution
    ... And SQL IS a data manipulation language, hence my problem with not using it ... that I had always used SQL Server to do data formatting for the past 12 ... instead of coding hooks in a dll to do this formatting, ... SQL, and T-SQL, is not a general purpose programming language. ...
    (microsoft.public.sqlserver.programming)
  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... are things called RESERVED WORDS. ... Steve - I don't agree with your method of "properly formatting" the ... virtually any programmer I know. ...
    (comp.lang.php)
  • Re: Set based solution
    ... coding off the database server, then it is worthwhile doing it. ... I'd argue that formatting things that differ from country ... > And SQL IS a data manipulation language, hence my problem with not using ...
    (microsoft.public.sqlserver.programming)
  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... queries code readability you are, of course, right, since a programmer ... are things called RESERVED WORDS. ... about formatting. ...
    (comp.lang.php)