Avatar of Harreni
Harreni
Flag for Saudi Arabia asked on

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

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
Microsoft SQL ServerDB Dev ToolsSQL

Avatar of undefined
Last Comment
Harreni

8/22/2022 - Mon
Éric Moreau

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 Horn

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

ASKER
Thanks a lot Éric for your reply.
I'm looking for other tools if you know any?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Éric Moreau

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Vitor Montalvão

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 :)
PortletPaul

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

ASKER
Thanks a lot all for your comments and help.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.