armgon
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SSMS is the standard, so I second Bill's suggestion. Another alternative is: DBeaver
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
»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,
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/
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.
Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Docs
»bp