Results 1 to 11 of 11
  1. #1
    Join Date
    May 2011
    Posts
    11

    Question Unanswered: Define Complex T-SQL

    Hi folks,

    i've been searching for a definition for what defines a Complex T-SQL,
    no luck at all so far. any ideas??

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    easy SQL -- anybody can do it

    difficult SQL -- you can't do it

    complex SQL -- i can't do it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Maybe it includes the square root of -1?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Two Definitions:
    Complex SQL: Stuff I can do and you can't.
    Overly-complex SQL: Stuff you did that should have been done by me.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by MCrowley View Post
    Maybe it includes the square root of -1?
    that'd be irrational SQL

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    When used with Transact-SQL, "complex" is a subjective term. It means whatever the reader and the writer want it to mean, which implies that it can mean one thing to the person that wrote it and something quite different to each person that reads it.

    I like the definition that an old friend used: Complex (or ambiguous) SQL will return different results on different SQL engines because there is more than one way to interpret the SQL statement.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r937 View Post
    that'd be irrational SQL

    Exactly!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  8. #8
    Join Date
    May 2011
    Posts
    11
    thanks everyone for your... sense of humor
    and then thanks pat giving it a try.
    so complex t-sql is something so complex it can't be defined.
    thats why i work with IT, it makes some sense after all

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    "Complex" is a relative term, Ariel. And you asked a definition from a group that is used to meticulous, exact, and repeatable results. Fuzzy logic does not fall comfortably within the realm of databases, or DBAs.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Hey now! I like all kinds of fuzzy stuff!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  11. #11
    Join Date
    May 2011
    Posts
    11
    I do understand the position blindman, this is a group of so far so good professionals. some a little prepotent I suppose but good professionals any how. my question was answered even "off-realm", there is no common sense to what it means. thanks people

Tags for this Thread

Posting Permissions

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