Results 1 to 5 of 5

Thread: queries

  1. #1
    Join Date
    May 2009
    Posts
    72

    Unanswered: queries

    Working with ms access , may be i have to unlearn to lear sql

    in ms access, i can create a qry, save it and open to edit it
    i can use an existing qry along with a table to create a new qry
    i can also use 2 queries to create a new qry

    can all this be done on sql
    if yes... please help

    help a newbee put his initial steps

    thanks
    krishnan hemanth

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by krishnanhemanth View Post
    in ms access, i can create a qry, save it and open to edit
    What's a qry

    Quote Originally Posted by krishnanhemanth View Post
    can all this be done on sql
    SQL is a language. It does not so support saving, opening and editing anything

  3. #3
    Join Date
    May 2009
    Posts
    72
    sorry about the short form.... qry i meant was QUERY

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by krishnanhemanth View Post
    can all this be done on sql
    presumably by "sql" you are referring to microsoft sql server

    the answer is yes, the equivalent to a saved query in ms access is called a view in ms sql server (and in pretty much all other database systems as well)

    you can create and save a view, and you can edit it in practically the same manner that you edit a saved query in ms access (i.e. by editing the source code of the SELECT statement)

    you can use an existing view along with a table to create a new view

    you can also use two views to create a new view

    check it out, it's covered very nicely in da manual
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    nice one, johntech

    copied word for word right out of da manual
    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
  •