Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2008-02-13 : 09:06:51
|
| I'm reporting from a Microsoft SQL database (poorly documented unfortunately) and would like to find a 3rd party application to assist me in rapidly making Select queries. The ability to browse data in a field from the interface would be a plus. What are the best alternatives for rapidly creating these queries from some sort of builder or wizard? TIA. |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-13 : 09:12:27
|
| there is a 'query builder' type thing already packaged with sql server. have you tried that?Em |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-13 : 11:10:24
|
| Have you checked the Report Wizard?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-02-13 : 11:50:46
|
| How complex are these queries? Are these intended to be rough and ready "first cut" queries or optimal & well formatted "best practice" queries? |
|
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-02-13 : 12:36:44
|
| Thanks for the responses so far. To answer a few questions: I'm using SQL Server 2000. I use SQL Query Analyzer but there doesn't seem to be a click and drag type of interface or wizard with that. So, I'm stuck typing out my database and field info along with joins and such. Am I not seeing some functionality here? Also, since I'm a relative beginner, I haven't even thought about "best practices" yet. Ideally, I would like a tool that would assist me with both. TIA. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-02-14 : 07:21:37
|
| sqlprompt from red-gate.com will give you auto-sense/auto-complete typing functionality....cheap, cheerful and a very useful toolkit for any developer/dba. plus it's available on try/return. |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-15 : 03:41:23
|
| in sql2000, rather than query analyser if you have enterprise manager right click on a table and chose 'query'. it then opens a query builder similar to Access i supposeEm |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-02-15 : 08:51:12
|
| I'll second Andrew Murphy - I use SQL Prompt and love it. It will also auto complete joins in queries for you based on the declared relationships between tables. It also has a snippets feature. You create a snippet and assign a code (say s@). Write the code and hit tab and the code you typed is replaced by the snippet. So - at the most basic you can make a snippet for a simple SELECT statement, hit tab and then you just fill in some table and column names... using the intellisense feature! |
|
|
|
|
|
|
3rd Party App for building select queries faster?