End-user Query Builder Tool?

Question

End-user Query Builder Tool?

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

MS Access is excellent for that. Link it to the SQL server, query building can be all drag-and-drop and clicking, without writing a line of code.

Reporting Services can do something similar, but Access is pretty intuitive and pretty easy to learn.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

LutzM SSC Guru Points: 107049 More actions · Answer 2

GSquared (2/2/2010)
MS Access is excellent for that. Link it to the SQL server, query building can be all drag-and-drop and clicking, without writing a line of code. ...

I thought of Access as well but I'd like to add some limitations:

- the server should not be a production system (I'd rather use a mirrored db)

Reason: AFAIK, Access is using an ODBC driver that'll actually copy all data to the client side and will do every kind of JOINS, WHERE clauses on the client side. So, it may take a moment to get just a few rows as a result set of two tables with a some hundred thousand rows used in a join due to "data traffic"... Meanwhile, the server side tables might be locked...

- the connection should have a user with limited readonly privileges

Reason: OP's statement "power-users with no T-SQL experience"

- It depends on the MS Office version that's available whether Access is included or not, and there is a cost difference IIRC...

- The results of those queries must not be business crucial

Reason: If power users have no T-SQL experience they might use an inner join where an outer join would have been required leading to wrong results

Other than that: I'll second Gus. 🙂

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

ssmagin Valued Member Points: 65 More actions · Answer 3

MS Access is good, but it isn't free and it's visual query builder is not too powerful as sometimes needed. Moreover, it does not support specific options of SQL Server dialect.

You may have a look at FlySpeed SQL Query. It is free if you don't need export to Excel and printing and it has the best visual query builder i've ever seen with full support of MS SQL dialect. Of course, it is able to build queries with OUTER joins, as well as sub-queries, derived tables and CTE.

rozrobnyk SSC Enthusiast Points: 100 More actions · Answer 4

If you are looking for some component for inclusion into your own application then you should look at EasyQuery.NET[/url].

This tool really simplified data searching and filtration for the users of our application.

Jamie Ingram-729524 SSCommitted Points: 1575 More actions · Answer 5

SQLExcel is quite good. It's free.

It allows you to create queries similar to MS Access query builder, and you can save the queries in a network location for other people to use.

Jamie

We are the pilgrims, master.
We shall go always, a little further.