Powerful SQL Query Tools

Question

I am looking for a tool to help you create complex SQL queries. It can sometimes be difficult to verify if the query results are correct. It is especially easy to get queries joining multiple tables to return too little or too much data.

The tool should at least include the creation of test tables, some kind of visualization, how queries collect their data and, I hope, better understand cases of errors than, for example, Oracle.

Are there tools like this, or should I stick to creating test cases manually, filling them with test data and sending all kinds of queries using SQuirrel SQL?

Answer 1

? (, SSMS SQL Server, Toad Oracle, MySQL Query Browser/Administrator MySQL ..), , , . , , , RDBMS , : .

Answer 2

SQL Server 2008 Management Studio Express (SSMSE), SQL Server. , , , .

SQL Server (-) .

Answer 3

, , , . , . temp, . , , , temp table.

Answer 4

Of course, it’s not a free open source solution, but I believe that Quest Software TOAD meets your requirements. Quest seems to offer many tools in this space ... they have tools for modeling and analysis, however I never used a modeler or analyzer.

I personally have experience with the commercial version of TOAD for Oracle. At first it is a GUI, but after you mentally filter out all the extra buttons that you will never use, they are manageable.