SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    TIP: Writing Readable SQL

    Many of you could make life SO MUCH EASIER for yourselves (and for us poor souls who try to help you) if you would only follow the general principles in this document (although it's written for MSSQL, the same hold true for pretty much every DB out there):
    http://msdn.microsoft.com/library/de...qd_14_97fp.asp

    So, help yourself, and help us to help you!!
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  2. #2
    SitePoint Addict EvilDoppler's Avatar
    Join Date
    Dec 2001
    Location
    Perth, Australia
    Posts
    217
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks for that link...

    funny enough though, i'm not MS educated and never really learned SQL through any MS database - but it appears that the systematic construction of SQL, on a readable basis, goes for SQL in general.

    That comment was just to confirm your reasoning that sound SQL isn't just limited to MSSQL.

    Cheers
    * Due to the last tax raise our prices has risen
    * - answers w/o thought $1 - answers w/ thought $3
    * - correct answers $10
    * - Dumb stares are still free


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •