Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.
Thanks,
Dave
On 25 Ott, 17:14, FrozenDude
> Does anyone know of or have a favourite 3rd party Visual Query
> Builder? We are looking for a very easy to use interface that
> provides SQL code verification, table joins etc.
>
> Thanks,
>
> Dave
why not sql server management studio? with sql express it's free.
ciroteo wrote:
> On 25 Ott, 17:14, FrozenDude
>> Does anyone know of or have a favourite 3rd party Visual Query
>> Builder? We are looking for a very easy to use interface that
>> provides SQL code verification, table joins etc.
>>
>> Thanks,
>>
>> Dave
>
> why not sql server management studio? with sql express it's free.
>
Better than what is built into Access?
Bob Alston
@newsfe02.lga:
> ciroteo wrote:
>> On 25 Ott, 17:14, FrozenDude
>>> Does anyone know of or have a favourite 3rd party Visual Query
>>> Builder? We are looking for a very easy to use interface that
>>> provides SQL code verification, table joins etc.
>>>
>>> Thanks,
>>>
>>> Dave
>>
>> why not sql server management studio? with sql express it's free.
>>
> Better than what is built into Access?
Much better.
--
lyle fairfield
The *only* third party SQL tool I've ever heard of anyone (I trust)
use was called "WinSQL". I remember being told it was freeware,
although they wanted you to register.
I remember being shown the tool once, and it was visual (more like SQL
Enterprise Manager then Access), and I remember thinking it was pretty
cool, but I didn't have a need for it when it was being shown to me,
and I pretty much forgot about it until just now.
Personally, I've never really found a need for it, but.....
(I carry EiSQLw on my flash drive, and it works quite well for me, but
it isn't a "visual" tool.)
Search for "WinSQL" at your favorite search engine, and let us know if
you like it.
On Thu, 25 Oct 2007 08:14:39 -0700, FrozenDude
wrote:
>Does anyone know of or have a favourite 3rd party Visual Query
>Builder? We are looking for a very easy to use interface that
>provides SQL code verification, table joins etc.
>
>Thanks,
>
>Dave
Please Post Any Replies To This Message Back To the Newsgroup.
There are "Lurkers" around who can benefit by our exchange!
"FrozenDude"
> Does anyone know of or have a favourite 3rd party
> Visual Query Builder? We are looking for a very
> easy to use interface that provides SQL code verifi-
> cation, table joins etc.
What "flavor" of SQL? Everybody's got their own little nuances.
For Access, the Access Query Builder is peachy keen.
For Microsoft SQL Server, there's a very nice Enterprise Manager.
Several years ago, I did some work with Informix and don't recall that it
included a Visual Query Builder, nor that the prime contractor on that
project licensed a third-party one. The DBA, perhaps a little grudgingly,
allowed me to create some Views to force server-side processing on some
modestly complex queries for reports, and that was an exercise in "SQL
Masochism" because I just had to sit there with nothing but the equivalent
of notepad and my bare brain and write SQL _from scratch_.
He used a third-party data modeling system, ERWIN, to design, redesign, and
implement the tables and relationships -- I don't remember what it cost,
exactly, but I do remember it was NOT "cheap". There are quite a number of
others, too, and, from my observation, all are expensive, but even so, there
are tiers of pricing... ranging from "just plain expensive" to
"flabbergastingly outrageously expensive." But that isn't what you are
asking about, I think.
Larry Linson
Microsoft Access MVP
On 25 Ott, 17:14, FrozenDude
> Does anyone know of or have a favourite 3rd party Visual Query
> Builder? We are looking for a very easy to use interface that
> provides SQL code verification, table joins etc.
>
> Thanks,
>
> Dave
Here (free):
http://www.datatime.eu/DataTimeUniversal.htm
http://www.datatime.eu/download.aspx
For problems/questions: http://groups.google.it/group/DataTime
-P