asked on

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.

prismabi

ASKER

See previous post, for complex queries, here:
https://www.experts-exchange.com/questions/21405589/What-is-the-best-Query-Designer-for-complex-SQL-queries.html

Anthony Perkins

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:
https://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.

prismabi

ASKER

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

Anthony Perkins

>>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.

prismabi

ASKER

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.

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

prismabi

ASKER

Ok, i see i have no choice.
Thanks