Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Free / Paid tool or Addon for building SQL Server T-SQL Queries
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.
Microsoft SQL Server
DB Dev Tools
8/22/2022 - Mon
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.
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.
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
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
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.
See how we're fighting big data
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
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 :)
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.
INNER JOIN table2 ON table1.fk = table2.pk
WHERE table1.column3 = 'value'
There are many ways to learn SQL available.
Thanks a lot all for your comments and help.
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent