Free / Paid tool or Addon for building SQL Server T-SQL Queries

Harreni
Harreni used Ask the Experts™
on
Hi Experts,

Is there any free / Paid tool that visualize SQL queries and make more complex queries easier rather than MS SQL studio? Looking for your recommendation.


Thanks a lot in advance.
Harreni
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Directly in SSMS, you can create a view to use its designer. You don't need to save and use the view if you want to only copy the query.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Other than SSMS (as Eric states) none that I know of, and in the long run I'm not sure it's a good idea to be dependant on a UI for querying as opposed to knowing the T-SQL.

Author

Commented:
Thanks a lot Éric for your reply.
I'm looking for other tools if you know any?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Senior .Net Consultant
Top Expert 2016
Commented:
you mean something like this: https://www.devart.com/dbforge/sql/querybuilder/
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Are you talking about something similar to MS Access query builder?
If so, I don't know and really I don't have any kind of interest in those tools since I'm so used to code query statements that only thing that I need is a good code indentation to visualize the query in my head :)
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Commented:
Once a query gets complex then "simple" query builders can fail to be simple, or fail to comply with ones needs.

If the query is simple, then it is more productive to learn sufficient SQL to achieve that. The skeleton structure of a select query just gets applied over and over again, adapting to the names of tables and columns as they are introduced to the query.

SELECT
      table1.column1
    , table2.column2
FROM table1
      INNER JOIN table2 ON table1.fk = table2.pk
WHERE table1.column3 = 'value'

There are many ways to learn SQL available.

Author

Commented:
Thanks a lot all for your comments and help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial