VISUAL QUERY TOOL OFFERS DISCOUNTS AND FREE UPDATES.Krell Software has released OmniView v2.0, a data editing and querying tool for Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. 7/2000 that greatly simplifies data manipulation Processing data. tasks for anyone working with SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. databases. Not just another visual query tool, OmniView is a feature-rich data manipulation application which makes working with SQL Server database content quick and easy for a wide range of user skill levels. Database administrators and developers can examine and change data more rapidly and conveniently with OmniView than with the native tools provided with SQL Server. But other types of users often need to work directly with database content as well, including project managers, quality assurance teams, technical support staff, trainers and sometimes even customers. Often these users are not as proficient pro·fi·cient adj. Having or marked by an advanced degree of competence, as in an art, vocation, profession, or branch of learning. n. An expert; an adept. with the more developer-centric SQL Server tools, but OmniView allows them to be more productive and lessens the workload on DBAs to support them. OmniView allows you to examine data from any table or view just like a spreadsheet. You can add, change or delete To remove an item of data from a file or to remove a file from the disk. See file wipe, trash and undelete. 1. (operating system) delete - (Or "erase") To make a file inaccessible. data just as easily as you would within a spreadsheet, without writing any SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. queries whatsoever. In addition, you can create queries against data using a simple point-and-click interface that does not require any SQL knowledge. Build expressions by selecting fields, operators, and values from dropdown lists. OmniView transforms this behind-the-scenes into the appropriate SQL and performs the query for you. Power users or SQL-savvy individuals can still write SQL expressions directly if they desire. Entire SQL scripts can be created from scratch using OmniView's advanced SQL editor. The editor includes auto-completion features that provide dropdown lists for database tables, SQL functions, and global variables. Write SQL quicker and more accurately without stopping to look up reference information. Any data returned by the query can be manipulated with the same powerful spreadsheet features described above. OmniView is available in two editions: Standard and Professional. The Pro edition is more suitable for advanced users. Pro allows you to work with stored procedures In a database management system (DBMS), it is an SQL program that is stored in the database which is executed by calling it directly from the client or from a database trigger. When the SQL procedure is stored in the database, it does not have to be replicated in each client. using a parameter (1) Any value passed to a program by the user or by another program in order to customize the program for a particular purpose. A parameter may be anything; for example, a file name, a coordinate, a range of values, a money amount or a code of some kind. editor to set parameter values and provides the same spreadsheet features for any data returned by the stored procedure. With Pro, you can also view and edit system table data directly in the spreadsheet. OmniView v2.0 runs under Windows 95/98/Me/NT4/2000/XP/2003, and is priced at $49.00 for Standard, and $59.00 for Professional. Multi-user discounts are available and minor version updates are always free. For more information, contact Krell Software, 1850 Oak Forest Drive South, Clearwater, FL 33759, USA. Trial version can be downloaded from http://www.krell-software.com/omniview/download.htm. For more information, visit http://www.krell-software.com or call 727/723-7559. |
|
||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion