• 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

    • Google's financial performance remains unaffected by competition from ChatGPT by Pradeep Viswanathan Today, Alphabet (Google's parent company) announced earnings for the quarter ended June 30, 2025. Overall revenue was $96.4 billion, up 14% YoY, thanks to the strong performance of Google Search & other, YouTube ads, Google subscriptions, platforms, and devices, and Google Cloud. Each of these businesses delivered double-digit growth in Q2. Google Cloud posted the strongest growth at 32% YoY, driven by the growing momentum of Google Cloud Platform (GCP), which includes AI Infrastructure and Generative AI Solutions. Its annual revenue run-rate is now more than $50 billion. In addition to revenue growth, Alphabet also posted strong margin improvement, reporting an operating income of $31.2 billion, up 32% YoY. Sundar Pichai, Alphabet CEO, said: During the earnings call, Sundar Pichai also revealed that the Gemini App now has more than 450 million monthly active users and that daily requests grew by over 50% since the last quarter. Despite ChatGPT’s explosive growth, Google appears unaffected so far, thanks to the strong financial performance of Google Search and the growing momentum of Gemini. However, it remains to be seen whether Google can hold its ground as ChatGPT increasingly attracts younger users who are turning to it over traditional Google searches.
    • Here is a better view 
    • I care more about ethical LLMs than open source LLMs. Would be great if they declare that the training data was sourced without copyright infringement.
    • Yep social media addiction is no different than alcohol or cigarettes.
    • I strongly feel it is a test bed for foldables. No other reason to slim down the phone even further, despite have a massive camera bump.
  • Recent Achievements

    • Collaborator
      fernan99 earned a badge
      Collaborator
    • Collaborator
      MikeK13 earned a badge
      Collaborator
    • One Month Later
      Alexander 001 earned a badge
      One Month Later
    • One Month Later
      Antonio Barboza earned a badge
      One Month Later
    • Week One Done
      Antonio Barboza earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      590
    2. 2
      ATLien_0
      225
    3. 3
      Michael Scrip
      167
    4. 4
      Xenon
      139
    5. 5
      +FloatingFatMan
      128
  • Tell a friend

    Love Neowin? Tell a friend!