hidden14
asked on
Simple SQL Query Editor
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
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
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.
If are you using MS-SQL Server use the Query Analyzer, it's very simple and have code highlights and others cool features.
ASKER
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?
I need a simple program, nothing to install on a server or something...
is there any?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will try the suggested programs..
Thank you :)
Thank you :)
ASKER
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..
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..