Post reply

Writing SQL scripts outside of SSMS

  • February 7, 2012 at 6:11 pm

    #391501

    So I like using SQL Server Management Studio because I can code and test at the same time. The problem is, I've recently used notepadd ++ and love the ability to change my code colour scheme. It's nice not staring at a white background all the time. I then changed the colour schemen in SSMS, but it's just not the same. Can't configure the results pane (even though it does give you the option, it just doesn't take effect).

    So it brings me to my question: What program do you all use to write your SQL scripts and so forth? I like being able to simply run a select statement and see my results right there and then, so is there a good app that allows me to do this that isn't SSMS?

  • February 7, 2012 at 6:51 pm

    #1444253

    linqpad is something i always carry in my portable apps flash drive;

    http://www.linqpad.net/

    it's got multiple query window/tabs, syntax highlighting as well as an object explorer and ability to run/test scripts; it's lighter weight than SSMS, but assumes you have >NET framework installed.

    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