|
|
SQLIdl
|
|
|
|
|
|
|
Версия: |
1.0 |
Автор: | ABIdeal.com |
Лицензия: | Shareware |
Скачать |
Цена: | $10 |
Описание:
SQLIdl is a Universal Web based Command Line Database (SQL) Tool for Application Developers
Features:
- Execute SQL Commands (DML/DDL)
- Invoke from Windows Start-->Run (command line)
- Connect any database by changing the connection string at run time. Tested databases are:
- Oracle
- SQL Server
- Preconfigure settings, so that you need not bother about typing in everytime:
- Connection string (Database, username, password)
- Frequently used SQLs
- SQLs for retrieving table/view/trigger/stored procedure definitions
- DML commands like Insert/Update need a password for preventing tampering
of database opened up using this utility. This Password is configurable (default: mypwd)
- Generation of Insert/Update command based on query results.
Retrieve from Oracle and insert/update into SQL Server or vice-versa
as it is or after typing in changes visually!!!
- Multiline data can be retrieved, changed and updated back
- Works fine with CLOB/LONG types
- Use multiple statements separated by semicolon!!! For ex: select * from dept;select * from emp
Requires .Net Framework (I use v1.1), MDAC 2.6, Internet Explorer (IE 5.5)
Installation and usage:
After installing to a IIS Virtual Folder, open Web.config from the Virtual folder and change the key conStr_def to point to your database. Please change other values if necessary.
open IE and type in as follows:
http://localhost/SQLIdl/SQLIdl.aspx
You would need to provide the correct virtual folder if you changed it during installation. Type in your SQL query and enjoy!!!
To install the command line utility, simply copy the two files SQL.exe and SQLIdl.ini to your workstation windows system32 folder, open SQLIdl.ini in notepad and provide the correct path to IIS.
Now just invoke run from Start Menu, type in your query as follows :
sql "select * from dept"
It is THAT simple!!!
If you like SQLIdl, please buy ($10 only).
Скриншот:
|
|
|
|
|
|
|
|
Афоризм
|
|
|
|
|
Жизнь не горька для того, кто твердо убежден, что вовсе не жить - не беда. Эпикур
|
|
|
|
|
Анекдот
|
|
|
|
|
Молодая женщина жалуется своей подруге, что ее муж пьет. -- Если ты знала, что он пьет,-- удивилась подруга,-- зачем же за него вышла? -- Я понятия не имела, что он пьет. И вдруг однажды он при- шел домой трезвый...
|
|
|
|
|
Прикол
|
|
|
|
|
Некоторые женщины говорят, что им нечего надеть. Другие с готовностью это демонстрируют
|
|
|
|
|
|