Solved

Simple SQL Query Editor

Posted on 2004-03-28
8
691 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
 
LVL 30

Expert Comment

by:Mayank S
ID: 10711595
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sum13 challenge 24 90
no14 challenge 14 62
Python 2.7 - French characters 6 58
wordlen challenge 3 60
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 …
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

919 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now