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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Sql server query gui tool

Author  Topic 

gamaz
Posting Yak Master

104 Posts

Posted - 2008-06-12 : 12:43:39
I was wondering if there is any free sql server GUI query tool that can help to do quick joined queries without wiring code. Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-12 : 13:54:01
Enterprise Manager can write the code for you, just right click on one of the tables, go to open table, and then to query. I don't recommend it though as it can produce some very inefficient code.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

gamaz
Posting Yak Master

104 Posts

Posted - 2008-06-12 : 15:15:21
Thanks Tara. The problem with this tool is that it cannot save the query.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-12 : 15:20:09
Just copy/paste it into Query Analyzer to save it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

gamaz
Posting Yak Master

104 Posts

Posted - 2008-06-12 : 15:52:03
Thanks for the advise. Did not think of it at all.
Go to Top of Page
   

- Advertisement -