• 0

SQL text Editor


Question

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
  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

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
  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.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • I see you subscribe to the Linux/macOS approach to winning over converts...
    • As we get closer to October 2025 and the end of Windows 10 support, Windows 11 will pick up its pace and soon become the most popular desktop operating system worldwide. That's an assertion. It's also quite possible that the only growth will come from attrition as people and companies buy new machines that only come with Win11. It's also possible that we'll get a literal repeat of Win XP and Win 7, where a large number of users just waited until Microsoft gave in and fixed the core problems that the consumers were complaining about in Win Vista and Win 8 when they released Win 7 and Win 10.
    • It's significant growth for Linux considering the market share, so it could have had that effect I described.
    • Microsoft and Crowdstrike announce partnership on threat actor naming by Pradeep Viswanathan Whenever a cyberattack is discovered, companies disclose it to the public and assign it a unique name based on their internal procedures. Unfortunately, this leads to inconsistencies, as each company has its own naming conventions. As a result, the same threat actor behind a cyberattack may end up with multiple names, causing delays and confusion in response efforts. For example, a threat actor that Microsoft refers to as Midnight Blizzard might be known as Cozy Bear, APT29, or UNC2452 by other security vendors. To address this issue, Microsoft and CrowdStrike are teaming up. These companies will align their individual threat actor taxonomies to help security professionals respond to cyberattacks with greater clarity and confidence. It’s important to note that Microsoft and CrowdStrike are not attempting to create a single naming standard. Instead, they are releasing a mapping that lists common threat actors tracked by both companies, matched according to their respective taxonomies. The mapping also includes corresponding aliases from each group’s naming system. You can view the joint threat actor mapping by Microsoft and CrowdStrike here. Although this threat actor taxonomy mapping is a joint effort between Microsoft and CrowdStrike, Google/Mandiant and Palo Alto Networks' Unit 42 are expected to contribute to this initiative in the future. Vasu Jakkal, Corporate Vice President of Microsoft Security, wrote the following about this collaboration with CrowdStrike: As more organizations join this initiative, the collective defense against cyber threats will undoubtedly be improved.
  • Recent Achievements

    • First Post
      chriskinney317 earned a badge
      First Post
    • Week One Done
      Nullun earned a badge
      Week One Done
    • First Post
      sultangris earned a badge
      First Post
    • Reacting Well
      sultangris earned a badge
      Reacting Well
    • First Post
      ClarkB earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      172
    2. 2
      ATLien_0
      125
    3. 3
      snowy owl
      122
    4. 4
      Xenon
      116
    5. 5
      +Edouard
      93
  • Tell a friend

    Love Neowin? Tell a friend!