Solved

Simple SQL Query Editor

Posted on 2004-03-28
8
695 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 30

Expert Comment

by:Mayank S
ID: 10711595
0
 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
fizzArray2 challenge 1 112
matchUp  challenge 6 82
Re-position sub-options beneath the TAB 7 112
CONDITIONAL MAX STATEMENT IN T-SQL 3 103
Navigation is an important part of web design from a usability perspective. But it is often a pain when it comes to a developer’s perspective. By navigation, it often means menuing. This is less theory and more practical of how to get a specific gro…
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 goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

752 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