Link to home
Start Free TrialLog in
Avatar of Harreni
HarreniFlag 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
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

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

ASKER

Thanks a lot Éric for your reply.
I'm looking for other tools if you know any?
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

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

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

ASKER

Thanks a lot all for your comments and help.