Notepad++ has an "SQL" language for basic editing SQL, allows collapsing and highlighting and such. For heavier editing I've used Squirrel SQL client, it's Java based and like below, it also requires a JDBC driver.
On Fri, Apr 2, 2010 at 7:55 AM, LRS Scout <[email protected]> wrote: > > Not sure about the advanced features but I use quantum db an eclipse plugin > and I love it. Annoying thing is you have to register the jdbc type 4 > driver for whatever DB you are using yourself. > > I will say, it makes performance more closely match what you will find in > production because you are using the same jdbc driver, and not a different > protocol. > > -----Original Message----- > From: Matthew Smith [mailto:[email protected]] > Sent: Thursday, April 01, 2010 4:20 AM > To: cf-community > Subject: better sql editor > > > I'm working on a rather complicated stored procedure. Lots of nesting with > if's and such. > > Are there better tools to edit sql code? something that will show me where > I am in nested code and handle the formatting? > > Thank you. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:314839 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
