question

Peter.Eden avatar image
Peter.Eden asked

Which Client SQL query writer?

I am a newbie to SQL (well I used it for a while 7 years ago). We have just had new accounting software (Exchequer) installed and I want to query it using SQL. I have managed to do this via MS Query but can only join two tables (outer join?). What client based SQL software would you suggest that I could use to write SQL queries which I can then distribute to the rest of the team? Apologies if this doesn't make sense ! :)
queryclient
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
Do you want to send them the queries so they can run them or do you want to send them the query results (perhaps formatted) so they can view/analyze them?
0 Likes 0 ·
Peter.Eden avatar image Peter.Eden commented ·
Ken, I want to embed the query in an Excel workbook so that they can refresh it and work with it. We are used to working with ODBC links to our old software (Sun).
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Remember, the site works through votes. For all helpful answers you can vote them up by clicking on the thumbs up. If any one answer, even your own, lead to a solution, click on the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
I write all my queries using the SQL Server Management Studio software that comes with SQL Server. In addition to that tool I also use a tool from Red Gate Software, my employer, called SQL Prompt that acts as a code completion tool. That's it.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Diwakar avatar image
Diwakar answered
I use SQL server management studio query editor and if one want to see table relations and create a query by visualizing the table, could possibly use Query Designer (SQL Mgmt Studio | Query | Query Designer).
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Peter.Eden avatar image
Peter.Eden answered
I have half found what I am looking for.... http://www.albahari.com/queryexpress.aspx This allows me to write queries from my desktop but it would be really useful to see the joins in the tables, especially as I am quite new to this. The idea is to write queries from my desktop and not have to log onto the SQL server itself.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You can just install SSMS locally on your machine. You don't have to install SQL Server. This will prevent you being forced to remote into the machine too.
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
How you can test the queries without connecting to SQL Server. To get that tool loaded up with tables, etc., you'll have to connect to the server instance.
0 Likes 0 ·
Peter.Eden avatar image Peter.Eden commented ·
Sorry, I meant without having to actually go onto the server using remote desktop etc. Obviously I will log into the SQL database.
0 Likes 0 ·
Diwakar avatar image Diwakar commented ·
The suggested SQL Express query editor does not work like a SSMS Query editor. SSMS Query editor has lot of cool features like Keyword identification, word complete, intelisence etc. But this is tool does not require system requirements like SSMS and can be used irrespective of any users. Thanks for pointing out this tool.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.