August 21, 2002 at 10:35 am
Hello all,
any recommendations on sql editors. I downloaded embarcadero rapid sql and it looks pretty good.
thanks
August 21, 2002 at 11:57 am
Im still using Query Analyzer, reasonably decent and the price is right!
Andy
August 22, 2002 at 12:43 pm
mrd101,
Is there a reason you like embarcadero over Query Analyzer?
Steve
Steve Miller
August 22, 2002 at 1:21 pm
One other nice thing. RapidSQL used to work offline, no SQL needed. However with the personal edition in 2000, not sure this is a big selling point.
Steve Jones
August 22, 2002 at 1:21 pm
Embarkadero was pretty good until 2000. Now with templates, color coding, I think QA works great. RapidSQL sorta had VSS integration, but didn't work well for me. Haven't looked at it since 2000.
Steve Jones
August 28, 2002 at 10:11 am
we will have three db systems soon(oraclem,sql and informix. I was looking for something that would work in all three. Im not sure that rapid sql works with informix yet. thank you for your opinions
btw i like query analyzer
August 28, 2002 at 1:22 pm
I use either Query Analyzer or whatever my favorite text editor of the day is with shelled/captured osql. The new templates feature in Query Analyzer, though not up to snuff with any professional editors, makes some typing a lot easier. For some frequent queries that I need to quickly sort/parse/copy/paste/email, I have Excel documents with the query results on a sheet (from Data, Get External Data), and all I have to do is click the (!) button to refresh it. It beats copying and pasting.
- Troy King
- Troy King
August 28, 2002 at 2:27 pm
I simple use notepad or QA depending on which is handy. QA of course has color coding for SQL Server but I just don't care to pay for something I can do wihtout. I work between MS SQL, Sybase, Oracle, Informix, and DB2. I have made enough mistakes to feel I pretty safe in my coding.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 28, 2002 at 5:09 pm
If I'm not using QA, I'll use TextPad. It's Shareware, and there are downloadable color schemes for commands. Also, you can create commands with keyboard shortcuts to execute an isql or osql or equivalent client tool. You can even set it to prompt for parameters.
I use it for T-SQL, PHP, Perl, VBScript, Java, and most other "light" coding. It works well as long as you don't need a lot of error checking. If you do, TextPad is not the right tool. It also doesn't have the ability to see what objects are there, view query plans, etc., that you get through QA.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Edited by - bkelley on 08/28/2002 5:09:42 PM
K. Brian Kelley
@kbriankelley
August 29, 2002 at 9:26 am
When I was coding Oracle, I had a coworker that really enjoyed using Textpad. I went mostly went with the tools Oracle provided for me. In SQL Server, I use QA.
Steve
Steve Miller
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply