• 0

SQL text Editor

Asked by mealies,

 Share

Question

Rising Star

mealies

Posted
Posted

HI

I do lots of database development work on SQL 6.5 and SQL 2000, now SQL 2000's IDE is not too bad but 6.5 is awful.

Can anyone recommend a SQL text editer. I don't need something that actually connects to the database, just something that i can write in and then copypaste into SQL 6.5. I suppose like a advanced Notepad kind of program, something with line numbers and syntax highligting. Any Ideas?

Thanks

Link to comment
https://www.neowin.net/forum/topic/476023-sql-text-editor/
Share on other sites

4 answers to this question

Recommended Posts

  • 0
Enthusiast

evolver

Posted
Posted
  mealies said:

HI

I do lots of database development work on SQL 6.5 and SQL 2000, now SQL 2000's IDE is not too bad but 6.5 is awful.

Can anyone recommend a SQL text editer. I don't need something that actually connects to the database, just something that i can write in and then copypaste into SQL 6.5. I suppose like a advanced Notepad kind of program, something with line numbers and syntax highligting. Any Ideas?

Thanks

UltraEdit?

  • 0
Rookie

lbmouse

Posted
Posted

If you didn't already know, you can use the Query Analyzer that came with SQL 2000 even in 6.5. For a free program that acts like an analyzer for MS Access, I've used Access Query Analyzer by Jeff Key.

I highly recommend purchasing UltraEdit-32. It is very good and does a lot more than just SQL editing... unfortunately it is not freeware. For a little more power with SQL ops, compatibility with Oracle/SQL Server/DB2/MySQL, and a freeware license, I've used Toad and it is not bad. The biggest disadvantage is that you have to download and reinstall every 90 days.

  • 0
Grand Master

Linkinfamous

Posted
Posted
  mealies said:

HI

I do lots of database development work on SQL 6.5 and SQL 2000, now SQL 2000's IDE is not too bad but 6.5 is awful.

Can anyone recommend a SQL text editer. I don't need something that actually connects to the database, just something that i can write in and then copypaste into SQL 6.5. I suppose like a advanced Notepad kind of program, something with line numbers and syntax highligting. Any Ideas?

Thanks

sql managment studio express 2005 should be able to work.

This topic is now closed to further replies.
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • Popular File Explorer alternative Files gets signature check, improved dual-pane, and more

      By Chay Meredith · Posted

      Files still rely on classic windows indexing rather than methods that 'everything' uses. So search is suboptimal. The compression algorithm list is really lacking not comparable to winrar, 7zip and peazip... The gui looks nice, but windhawk is a thing. I don't understand what files brings in 2025.
    • WhatsApp's guest chats feature has a surprising catch

      By Nick H. · Posted

      I think I only know of a handful of people that don't have WhatsApp - somewhat frustratingly they're my OAP group that I support. But in those situations they always prefer to phone rather than text anyway, so this won't really do much to help me. If the functionality of Guest mode is only one-to-one messages and no media transfers, I can't see it getting used that much. A group option with photo attachments would be useful for my other business to send out a notification to our clients including those that don't have WhatsApp.
    • Firefox 141.0.2 is out, fixes crashes on systems with Nvidia GPUs and more

      By TarasBuria · Posted

      Firefox 141.0.2 is out, fixes crashes on systems with Nvidia GPUs and more by Taras Buria A small update is rolling out for Firefox in the Release channel. Version 141.0.2 delivers three fixes to address problems with crashes on systems with Nvidia cards, web compatibility issues, and Web Developer Tool issues. Starting with the Nvidia bug, users reported that on Linux systems with older drivers, such as 560.35.03, an instant crash on startup occurs (bug 1978911). This issue does not affect Windows users. Next, the update fixed a web compatibility issue that was causing problems with canvas objects (bug 1978673). The third fix resolves Web Developer Tools crashes when inspecting pages with iframe elements (bug 1975277). Here is the full changelog from the official documentation. Firefox 141.0.2 is currently available from Mozilla's FTP only. It will start rolling out to existing users in a couple of hours. You will be able to get the update by heading to Menu > Help > About Firefox or by downloading an installer from the official website. On Windows, Firefox is also available in the Microsoft Store via this link. In case you missed it, Firefox 141 arrived a few weeks ago with a couple of new features, including AI-powered tab groups, vertical tab improvements, memory optimizations for Linux users, WebGPU support on Windows, and more features for the address bar. You can find full release notes for the update in our dedicated article.
    • WhatsApp's guest chats feature has a surprising catch

      By Elliot B. · Posted

      Clickbait title.
    • Report: Microsoft quietly disables vital Windows feature crippling many AMD Ryzen CPUs

      By Soeaker4thedead · Posted

      Clearly a lot of gamers. And I'm sorry but you are wrong, my 7800x3d (single ccd) offers huge benefits to me as a AAA 1440p gamer. And it's pretty dumb to crap on 1080p gamers as they make up like 90+% of steam gamers. But no, the x3d does not just offer benefits to esport gamers (one of the stupidest things I've seen in a while AND THATS SAYING SOMETHING.) Abd when I built my rig with my 7800x3d, I paired it with a RX7900xt and couldn't be happier.

  • Recent Achievements

    • First Post
      Soeaker4thedead earned a badge
      First Post
    • First Post
      kryptickid earned a badge
      First Post
    • First Post
      Nemesis-IV earned a badge
      First Post
    • First Post
      Aidan Helfrich earned a badge
      First Post
    • Collaborator
      bullgod69 earned a badge
      Collaborator

  • Popular Contributors

    1. 1
      +primortal
      760
    2. 2
      ATLien_0
      187
    3. 3
      +FloatingFatMan
      151
    4. 4
      Xenon
      117
    5. 5
      wakjak
      113
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!