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?