[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

What is the best VISUAL Query Designer for SQL queries?

Dear experts,
What is the best VISUAL Query Designer for SQL queries?
I am a begining sql programmer.
I use QBE (MS Access) and it is very usefull, but is there a better environment to create and debug SQL queries?
Especially, is there a better tool for passthrough queries and complex queries and subqueries?
Thanks in advance.
0
prismabi
Asked:
prismabi
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
The Query Analyzer in SQL Server is what I use (when I have to).

Making the jump from the QBE (Query By Example) grid in Access to the query Analyzer is not for the faint of heart.

VISUAL Query Designer for SQL is an attempt to make it "Easier" to create queries in SQL.

I would recommend learning to write your queries in the Query Analyzer (or in Access: "View-->SQL", the way I did) first so you understand the translation from Access queries to SQL.

THEN worry about tools that would make your job easier.

0
 
Jeffrey CoachmanCommented:
0
 
prismabiAuthor Commented:
thanks for the quick answer and the link.
I am trying VSD and i'll tell you soon my opinion.
0
 
prismabiAuthor Commented:
dear boag2000,
I didn't succeed to work with VSD,
so i'll take your advice and start working with the Query Analyzer.
Thanks for your help.
0
 
Jeffrey CoachmanCommented:
Glad I could help,

BTW: After you work with the Query Analyzer for a while, go back and play around VQD again.
It may be that you need more background in designing queries from scratch in order to appreciate VQD.

Good luck!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now