Post reply

Just a query tool

  • July 25, 2016 at 11:16 am

    #328657

    We do not want everybody installing the SQL Server client tools. SSMS exposes features these users do not need [and yes I know that security can limit what can be done ...] There are some people that want/need to run SQL queries against a SQL Server database but they do not need any management features. These users write simple SQL statements. If the tool is capable to show the tables/column names and maybe syntax assistance that would be good. SQL Server is the only type of connection necessary [no Oracle, MySQL, etc.]

    Does anyone have a favorite recommendation for a simple Query tool?

    Will appreciate any feedback. Thank you.

  • July 25, 2016 at 12:46 pm

    #1891880

    Linqpad[/url] is a good alternative; it supports a object explorer type of panel, and multiple tabs with syntax highlighting like SSMS does.

    it's also "portable", meaning you don't have to install anything, but it does assume you have the DotNet frameworks installed.

    i keep that on my flash drive along with code /sql backups.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply