Tools used in creating queries

  • Hi,
          can somebody help me how to use query tools such as TOAD or QUERYMAN .
    Is there any site where you can get information about it.
  • Why do you need to use those tools ? SQL Server has QA - Query Analyzer. As for the assistance woth QA, well there is BOL - Books Online.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • I did check book online but i cant find them.do you know how can i find stuff to actually use them

  • To get at he things I mentioned:

    Start-Programs-Microsoft SQL Server-Query Analyzer

     

    What exactly are you try to do ? Learn SQL ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • i have to use various databases in the company through standard SQL tools such as queryman or TOAD.In other words iam creating SQL queries against multiple databases.

     

     

  • To be more clear

     i just want to know how to use these tools i.e querymam or TOAD in creating queries . 

     

  • Are all of your databases SQL Server ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • no all of them are not in  sql server some are access and some in oracle also

  • If you can you write a transact SQL query for SQL Server or a SQLPlus query for Oracle then using Queryman or Toad is no different. However if you cannot write queries in each DBMS's own native tools, then using another tool will not help.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply