Thank this author by sharing:
By Steve Jones,
I'm not sure where I heard of this editor. I think it was on >Slashdot, but for whatever reason, I decided to try it out. It had a number of features that I had wanted, but are missing in different low-cost editors that I have used. Mainly, color coding of the various keywords and functions, and some flexibility!
What does that mean? Well, I program in T-SQL, HTML, ASP, VB, now starting C# and experimenting with PHP, Python, and other languages. In the past, I have used Query Analyzer for SQL, Interdev for Internet stuff and notepad for most everything else. However, I haven't been thrilled with Interdev, mainly because it is a little cumbersome and more expensive than I would like if I go somewhere else. What I really wanted was an editor that would adapt to different languages and was preparing to build my own (as a learning experience as well as a tool I would like).
Then I stumbled on EditPlus and decided to try it out. I went to the site (www.editplus.com) and downloaded it. It comes with a 30 day evaluation by default, so I installed it and started to work.
The first step was to edit some .ASP and .HTML files. I started the program, which looks as follows when you first get past the registration reminder.
Some nice things I like.
Some things I don't like and would like to see enhanced.
When I started the program up, I was intending on replacing Interdev and notepad and doing most of my non-SQL work in this tool. Since you can create your own templates, however, I decided to create a T-SQL one as a test and see how it worked. There is a user submitted MSSQL file for SQL 7, but I thought I might create my own. I quickly found a section in the help file that described each section of the syntax file. By opening the HTML syntax file and altering to suit my needs, I was able to easily build a syntax file for SQL commands. I have included a link to a SQL syntax file here, but it is by no means complete. In fact, it is only a quick and dirty job until I determine how to submit my file to the SQL compiler.
This is a handy editor. I've seen some others and had others recommended, but I've been extremely happy with this tool and have it on all my machines. If you do other development and want an inexpensive and flexible text editor, give it a try. Especially if you write for us :).
As always I welcome feedback on this article using the "Your Opinion" button below. Please also
rate this article.
Return to Steve Jones Home
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems....
SQL Server will not start.
You open up the ERRORLOG (...which I would only do with a text editor li...
Best Editor to use for TSQL
Management Studio would not appear in the start menu
SQL Server Agent will not start after changeing service account and there are no error logs.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.