Link to home
Start Free TrialLog in
Avatar of armgon
armgonFlag for United States of America

asked on

Looking for suggestions for a SQL Query tool to use with MS SQL Server?

Looking for options as to a stand-alone SQL Query Builder type application?


Any suggestions on such a tool either online or desktop?



Avatar of Bill Prew
Bill Prew

Microsofts SSMS is a free tool that includes query building.

Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Docs


»bp
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SSMS is the standard, so I second Bill's suggestion.  Another alternative is: DBeaver
Avatar of armgon

ASKER

Mainly looking for something that would assist me to write complex queries which I would use to create views.
What's your budget?

»bp
SQL Server Management Studio, Azure Data Studio, Visual Studio with SQL Server Data Tools.. all free.

But when query builder implies a UI to build queries, then I don't think it is a good idea. SQL is better written by hand than a graphical designer,
If you want something extra from SSMS then take a look here :
https://www.comparitech.com/net-admin/best-sql-query-builders/
RegGate also has some offerings, such as https://www.red-gate.com/products/sql-development/sql-prompt/ , but check out their site for others.  I've never used them, but have heard good things from fellow MVPs.
Cannot live without SQL Prompt. The intellisense of it is just awesome. And using a consistent formatting makes reading and thus working with T-SQL much, much easier.