I'm wondering if there's a better SQL Editor than MS Query Analyzer on the market? I like a lot of the functionality provided by QA but want extra stuff like you get in VB6: intelli-sense (sytanx prompting), auto-complete (CTRL+Space provides list of sp's and tables, etc.) plus any other time saving features.
I've tried a few products but nothing quite hits the mark. Is there a program you use and recommend I trial?
Quite franky I use the analyzer mostly. On the side, I do use ultraedit as my main editor. If you load a .sql file and configure transact-sql as filetype, the editor can deal with auto-complete. Ultraedit does have a few nasty traits though...
can you give examples so that i can watch out for them?
jup; these I know from the top of my head, their not devestating, sometimes just a bit annoying...
Macro implementation is poor.
Can't seem to get hold of it's regular expressions (but that's probably me). When UTF-8 Autodetect is turned ON, UEdit treats xml/xsd files by default as UTF-8 and saves them likewise (1 byte -> 2 bytes): xml parses won't deal with it.
oh: this is one really over the top:
create a new file
enter a single character on position 0,1
search for it, twice.
There are a few more, but don't recall them right now...
Is there a reason that you don't use Visual Studio to edit your SQL files? I don't remember if the tempates come with the Professional version or if I had to download them, but that sounds like the best answer I've heard for your needs.
pat, the reason i don't use visual studio is because i don't have it, that's why
but i know your question was not directed at me
Sorry, I should have been more explicit on that!
Yes, since Andy was looking for Visual Studio features, I assumed that he already has Visual Studio (an assumption, but it seems safe enough to me).
95% of the time I use Query Analyzer to edit my SQL, I rarely bother with anything else. If I'm already in Visual Studio editing something else, I don't have any problem editing a related SQL file there though.
Long ago and far away I had a near religous attachment to an editor (VI, then Brief), but I've become editor-agnostic. Then again, I was once religiously attached to both PL/1 and C, but have become language-agnostic. Of course, I was also pretty attached to IMAGE (an old HP database product) and Vulcan (an old CP/M database that became dBase), but now I'm even DB-agnostic. Amazing what happens over the years, and how mentally flexible you can become (too bad that doesn't work physically!!!).