Results 1 to 10 of 10

Thread: Syntax Builder

  1. #1
    Join Date
    Dec 2004
    Posts
    9

    Question Unanswered: Syntax Builder

    I'm looking for a "free" tool that will build sql statements for me.....anyone know of a good one?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Right click on any table in Enterprise Manger and select Query. It will bring up a GUI that will allow you to add and link more tables and refine your query. Much like the query designer built into MS Access.
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    Right click on any table in Enterprise Manger and select Query. It will bring up a GUI that will allow you to add and link more tables and refine your query. Much like the query designer built into MS Access.
    EDIT: Removed offending scream of insanity

    Excuse me.
    Last edited by Brett Kaiser; 01-06-05 at 15:32.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Dec 2004
    Posts
    9
    Quote Originally Posted by blindman
    Right click on any table in Enterprise Manger and select Query. It will bring up a GUI that will allow you to add and link more tables and refine your query. Much like the query designer built into MS Access.

    I Don't see that in my enterprise manager when I right-click on a table.

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    it looks like an agonizing scream but upon closer inspection i would have to say he's yawning and it's the internal bleeding that cause it to come out red...

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's a scream...why would a blind dude....well never mind..the blind leading...uh..

    Right click on table> Open Table > Query

    May god have mercy on your soul


    Use the Catalog to generate code...MOO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    check out this image for SQL GUI Goodness!
    Attached Thumbnails Attached Thumbnails HowToQuerySQL.jpg  

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Cripes, Brett! It's just a tool!

    In the interest of full disclosure, tready, when you have a table opened this way there is a good chance that the data is editable, so any changes or deletions you make in the grid will be written to the database tables. So DO NOT give end-users access to this functionality. For DBA use only!

    Plus, it does not necessarily generate neat code, and won't help with highly complex statements. But if you want to learn how to write simple joins and filters then you can do a lot worse than creating your query in the GUI interface, copying the code to Query Analyzer, and then editing/cleaning it up there.

    What was that?!

    I thought I just heard somebody scream....
    If it's not practically useful, then it's practically useless.

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

  9. #9
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    if you want a slow but graphical way to do this as well

    open access and set the database compatibility to ansi92
    link tables into access
    create queries in the query editor.

    or

    Pay for something.

    Disclaimer....
    I dont use this method nor do i condone this method of editing or querying any enterprise level database. microsoft access is a toy and should be treated as such and is not to be left out on the floor or at the bottom of the stairs where someone could trip over it. futhermore, as a toy do not confuse its ability to pretend to be a database tool with an actual tool. you could hurt yourself or someone close to you.
    finally, do not place microsoft access on your head or allow small children to play with it as there is the danger of suffocation.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    cute disclaimer

    my web site (see sig) runs on access

    but i also use coldfusion query caching so it works out rather well
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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