• 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 simply don't get why this "OS" exists. Who cares? Great, you can now run a Windows 95-era stupid game, super cool...
    • In the UK the standard edition has been priced at £69.99, the deluxe is £89.99, the super deluxe is .... £119.99 where the hell do they suggest these prices are coming from then! Sorry but at these prices I will not be buying when it comes out. It will be much, much later when the price has dropped considerably!
    • It'll just have $300 dlc instead, several season pass and at every moment you'll be left feeling you purchased the demo by buying the standard or deluxe editions, because the superdeluxe is how they meant to release the game in full.
    • Following higher pricing fears, Take-Two confirms Borderlands 4 won't be $80 by Pulasthi Ariyasinghe Video games going even higher in price has been a controversial subject as of late. Following the bump up to $70 in recent years, which has been vastly adopted by many publishers, now the price is slowly creeping up to be $80 for major releases. However, it seems Take-Two's latest game will not be following this new trend, despite what was being said in earlier reports. Take-Two and Gearbox today confirmed the launch of pre-orders for Borderlands 4, and front and center was the pricing information for the standard edition, which is set at $69.99. It seems the cooperative-focused looter shooter is not following in the footsteps of other high-profile $79.99 releases like Mario Kart World from Nintendo and the upcoming RPG The Outer Worlds from Microsoft. As for why many were expecting the Borderlands title to also be $80, Gearbox boss Randy Pitchford had alluded to the price hike recently. In a social media post in May, Pitchford answered a question from a fan regarding the game possibly being $80, to which he replied, saying that it was not his decision. "If you’re a real fan, you’ll find a way to make it happen," he went on to say, defending a possible $10 price hike. "My local game store had Starflight for Sega Genesis for $80 in 1991 when I was just out of high school working minimum wage at an ice cream parlor in Pismo Beach and I found a way to make it happen." In the end, Borderlands 4 is now confirmed to be releasing at $69.99 for the Standard Edition, with pre-orders available now. At the same time, a $99.99 Deluxe Edition and a $129.99 Super Deluxe Edition have also been confirmed, with each higher tier adding more cosmetic customizations as well as post-launch access to unannounced DLC content. Borderlands 4 launches September 12, 2025, across PC (Steam and Epic Games Store), Xbox Series X|S, and PlayStation 5. A Nintendo Switch 2 release is also planned to land later in 2025.
  • Recent Achievements

    • Explorer
      treker_ed went up a rank
      Explorer
    • Apprentice
      CHUNWEI went up a rank
      Apprentice
    • Veteran
      1337ish went up a rank
      Veteran
    • Rookie
      john.al went up a rank
      Rookie
    • Week One Done
      patrickft456 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      641
    2. 2
      ATLien_0
      274
    3. 3
      +FloatingFatMan
      171
    4. 4
      Michael Scrip
      155
    5. 5
      Steven P.
      140
  • Tell a friend

    Love Neowin? Tell a friend!