locked
Ad Hoc Queries RRS feed

  • Question

  • Hi,

    My company has recently begun switching from MS Access to SQL Server applications written in house.

    My question is,  does anyone have any recommendations on any Ad Hoc Query software that I can look at purchasing
    to allow users to query the SQL db without giving the end user anything too complicated ?

    Something with a simple interface that will allow them to run SELECT Queries.



    Thanks


    tattoo
    Sunday, December 14, 2008 5:34 PM

Answers

  • Here is a link to EMS SQL Query for SQL Server  , SQL Server client query tool.

    Query examples:

    http://www.sqlusa.com/bestpractices/


    Kalman Toth, SQL Server Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

    Sunday, December 14, 2008 7:46 PM
    Answerer
  • Visual SQL Designer is a tool that allows users to visually create complex SQL queries.  I don't know if it will meet your requirements because it may be too complex to be used by a non-SQL end user but for a free tool it's definitely worth the price.

    John K.
    Knowledgy Solutions
    http://knowledgy.org/

    Sunday, December 14, 2008 7:53 PM
  • Hi

    You can generate queries using Query Designer in SQL Server Management Studio (It is a tool which comes with SQL Server )

    Launch SQL Server Management Studio->Click New Query Window (Ctrl +N) ->Right click and click "Design Query Editor"

    You can get more information at the following link 
    http://msdn.microsoft.com/en-us/library/ms365414.aspx


    Thanks
    Sreekar
    Monday, December 15, 2008 7:30 AM

All replies

  • Here is a link to EMS SQL Query for SQL Server  , SQL Server client query tool.

    Query examples:

    http://www.sqlusa.com/bestpractices/


    Kalman Toth, SQL Server Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

    Sunday, December 14, 2008 7:46 PM
    Answerer
  • Visual SQL Designer is a tool that allows users to visually create complex SQL queries.  I don't know if it will meet your requirements because it may be too complex to be used by a non-SQL end user but for a free tool it's definitely worth the price.

    John K.
    Knowledgy Solutions
    http://knowledgy.org/

    Sunday, December 14, 2008 7:53 PM
  • Hi

    You can generate queries using Query Designer in SQL Server Management Studio (It is a tool which comes with SQL Server )

    Launch SQL Server Management Studio->Click New Query Window (Ctrl +N) ->Right click and click "Design Query Editor"

    You can get more information at the following link 
    http://msdn.microsoft.com/en-us/library/ms365414.aspx


    Thanks
    Sreekar
    Monday, December 15, 2008 7:30 AM