Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Simple SQL Query Editor

Posted on 2004-03-28
8
Medium Priority
?
698 Views
Last Modified: 2012-05-04
Hi experts,

does anyone know of any SQL query syntax editor.. that uses colors and that is simple and easy to use..
I need something to help me view my queries in an organized manner so it'll be easy to follow the SQL code and edit it..

I appreciate all your help..
Thank you
hidden
0
Comment
Question by:hidden14
8 Comments
 
LVL 30

Expert Comment

by:Mayank S
ID: 10702819
If you are working with Oracle, then try Toad. Its really useful - displays all the data in your tables in the form of an Excel sheet. You can add/ remove/ modify rows like that. You can right-click and add tables, choose data-types of columns using combo-boxes, get the query and code generated automatically, manage stored procedures and almost everything with it. It also has a query-editor - just the kind of thing which you want.
0
 
LVL 2

Expert Comment

by:TeddyZero
ID: 10704854
If are you using MS-SQL Server use the Query Analyzer, it's very simple and have code highlights and others cool features.
0
 
LVL 1

Author Comment

by:hidden14
ID: 10710619
Actually, i'm using MS Access.. but i need a little standalone program to help me edit my queries.. cause it's a bit hard to follow in the query editor used in MS Access.. it wears my eyes out..
I need a simple program, nothing to install on a server or something...
is there any?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 16

Expert Comment

by:warturtle
ID: 10758869
Hi,

You can download the editor VIM from http://www.vim.org/download.php#pc , its a self-installing editor. Can deal with atleast 70 different languages.

Moreover, you can open a .sql file and open it with GVIM, and it shows the SQL keywords in different colors, and data in other color.

Regards,

Warturtle
0
 
LVL 2

Accepted Solution

by:
Glowingdark earned 200 total points
ID: 10789009
Programmer's notepad has a mode for SQL Files (and a few other languages) which does syntax highlighting:
http://www.pnotepad.org/download.php

The Scintilla Text Editor (SciTE) also has an SQL mode, and many other modes, which also does syntax highlighting:
http://scintilla.sourceforge.net/SciTE.html


Kevin

0
 
LVL 1

Author Comment

by:hidden14
ID: 10795625
I will try the suggested programs..
Thank you :)
0
 
LVL 1

Author Comment

by:hidden14
ID: 10795650
Thank you all for your help..
I've tried the suggested programs..  "Programmer's notepad" that Glowingdark suggested is what i really need.. it does the trick..

I appreciate all your help..
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question