• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

What is the best VISUAL Query Designer for SQL queries?

Dear experts,
I am reposting my previous question, but this time for a begining sql programmer.
What is the best VISUAL Query Designer for SQL queries?
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?
Thanks in advance.
0
prismabi
Asked:
prismabi
  • 4
  • 3
1 Solution
 
prismabiAuthor Commented:
0
 
Anthony PerkinsCommented:
What is your database?  If the answer is MS Access your best bet is to move this question to a more appropriate Topic Area such as:
http://www.experts-exchange.com/Databases/MS_Access/

If it is MS SQL Server than Enterprise Manager is a fairly good but limited visual query designer.
0
 
prismabiAuthor Commented:
I came from Access, but now I have to deal with SQL server.
Is there something like Access QBE for SQL Server?
Enterprise Manager have a visual designer only for views.
You're right, i will repost tomorrow this question to the Access forum here.
Thanks
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Anthony PerkinsCommented:
>>Enterprise Manager have a visual designer only for views.<<
You can use it for any ad-hoc queries, but you are right you cannot save them.  In order to take full advantage of MS SQL Server, I suggest you wean yourself from Enterprise Manager and use SQL Query Analyzer.
0
 
prismabiAuthor Commented:
SQL Query Analyzer is fine for debugging, but not really visual.
The easiest way I found to design queries is to make an
Access project (.ADP), then you can use the Access QBE environment
for most stored procedures and functions, but not complex queries.
0
 
Anthony PerkinsCommented:
>>but not complex queries.<<
Exactly my point and yes I realize that SQL Query Analyzer is less visual, however it may be time you started understanding T-SQL.
0
 
prismabiAuthor Commented:
Ok, i see i have no choice.
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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