21. SQL Server Magazine - The Smart Guide To Building World-Class Applications sql Server Magazine is the technical guide to managing, mining, building and developing sql Server databases. The magazine includes tips on data recovery, data commands, database software, Visual http://www.sqlmag.com/

Home Hot Topics Active Directory Migration ... My Account Within: SQL Server Magazine Entire Network Advanced Search LOG ON Driving the Enterprise Network NT XP The Smart Guide to Building World-Class Applications Backup and Restore Change and Configuration Management Data Modeling Data Transformation Services ... Don't Miss Our New Web-Only Column: T-SQL 2005 In this month's installment of his T-SQL 2005 Web column, Itzik Ben-Gan describes three new SQL Server 2005 analytical ranking functions for calculating row numbers and other ranking values. Read it today! News Microsoft Fixes BizTalk Adapter Problem New BI Accelerators Available TechEd 2004: SQL Server 2005 to Get Encryption, Decryption Features ... More News [May 27, 2004] The Secret Lives of DBCC Commands Microsoft's unwillingness to document many valuable Database Consistency Checker (DBCC) commands has always been a pet peeve of mine. The SQL Server community would be well served by better command documentation. SQL Server Magazine Brian Moran June 2004 Buried Treasure in Your Backyard With SQL Server 2005 still on the distant horizon, how can you get the most out of your SQL Server 2000 system today? Dig into these seven valuable and often overlooked features. SQL Server Magazine Brian Lawton June 2004 Cycling with CTEs Recursive CTEs let you use short, efficient code to manipulate single and multi-parent hierarchies. With a bit of sophistication, you can even provide solutions to the toughest hierarchical problems—detecting cycles and sorting siblings.

22. Yardi Systems Experts, Myriad Consulting Offers Complete IT Consulting Information on solution designs for business reengineering. Windows 2000 Server Suite, Windows NT, NetWare 4.X and 5.X, Citrix Metaframe, Windows 95/98, UNIX, Microsoft sql, Oracle, Informix. http://www.myriad-csi.com/

This page uses frames, but your browser doesn't support them.

23. A Gentle Introduction To SQL A Gentle Introduction to. sql. An interactive sql tutorial using sql Server, Oracle, Mysql, DB2, Mimer sql, Postgresql and Access. SELECT statements including joins and functions. Tutorial Section . http://www.sqlzoo.net/

24. SQL Reference Page sql Reference Page. This page is obsolete. The authors of this page have General Information. US FIPS sql info. sql syntax information. http://www.contrib.andrew.cmu.edu/~shadow/sql.html

SQL Reference Page This page is obsolete. The authors of this page have not examined many of the tools and resources listed here, and do not make any guarantees as to their usefulness. If you discover that a link is out of date, or would like to see something appear here that is missing, send email to General Information SQL syntax information Programming Resources SQL software ... See Also General Information U.S. FIPS SQL info SQL syntax information SQL92 (SQL-2) syntax as of August 1992 SQL-3 syntax as of September 1993 Current draft of SQL-3 standard HTML translation of SQL-86, for demonstration purposes ... SQL92 specification draft Programming Resources SQL92 Persistent Stored Modules draft SQL Software Catalog of free database software GnuSQL mSQL (version 1) ... Mariposa SQL Tools Leroy Cain's SQL parser Miscellaneous Remote Database Access protocol DBMS info DB2 info page Empress info page Informix info page Ingres info page ... Sybase info page See Also Last updated 7/26/95 by Derrick Brashear

25. SQL Parser For ORACLE & DB2 SQL Dialects. Software Development Services. Takes sql statements as the input and then presents it in a structured way complete with proper indentation for sub clauses and capitalization of keywords. Commercial http://www.novosoft-usa.com/solutions/tools_sql.shtml

software development services company services solutions case studies ... SQL Pretty Printer through site projects only Backup software RTF TO XML © 2003 Novosoft LLC. SQL Pretty Printer The Pretty Printer takes SQL statements as the input and then presents it in a structured way complete with proper indentation for sub clauses and capitalization of keywords. It is implemented with using of our SQL parsing technology. There is a tool at Novosoft called SQL parser. It completes syntax parsing of DML (data manipulation language) statements for ORACLE v8 and DB2 v6 SQL dialects. These statements include INSERT, UPDATE, DELETE and SELECT statements. It also can parse certain DDL (data definition) statements such as CREATE TABLE and CREATE VIEW. The tool is used over three years in commercial product. Pretty Printer just demonstrates the ease of use of our SQL parser. It can be integrated with many other tools since the key idea is to present the statements parsed in a generic, dialect-independent internal format (abstract syntax tree). Demo is set by default for syntax parsing of DML statements for and DB2 v6 SQL dialects.

26. SQLCourse2 - Advanced Online SQL Training sqlCourse.com an interactive online training course for sql beginners. Advanced Online sql Training. Search Database Journal This unique sql Tutorial is the "sequel" to the highly successful sqlCourse.com site and will provide you with more http://www.sqlcourse2.com/

Click Here Free Newsletters: Database Journal DBA News Advanced Online SQL Training Search Database Journal: HOME News MS SQL Oracle ... Other Tutorial Links internet.commerce Find IT Products Vacations Promotional Products Cheap Auto Insurance ... Consumer Electronics internet.com Developer Downloads International Internet Lists ... Discover an alternative to expensive, traditional NAS appliances. Learn how NAS cluster software delivers unprecedented scalability, manageability and availability for Linux and Windows file serving. Click Here Welcome to SQLCourse2.com ! This unique SQL Tutorial is the " sequel " to the highly successful SQLCourse.com site and will provide you with more advanced easy-to-follow SQL Instruction and the ability to practice what you learn on-line with immediate feedback! You will receive immediate results on a web page after submitting your SQL Commands. This continuation course will provide you with critical need-to-know advanced features and clauses of the SELECT statement that weren't supported in the previous SQLCourse.com site. Everything you learn here will be ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements.

27. Information Technology - Database Language SQL (Proposed Revised Information Technology Database Language sql (Proposed revised text of DIS 9075) July 1992 (Second Informal Review Draft) ISO/IEC 90751992, Database http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

and ..................................................89 5.4 Names and identifiers ......................................98 6 Scalar expressions ...........................................107 6.1 and ................................168 7 Query expressions ............................................173 7.1 , and ....203 8 Predicates ...................................................205 8.1 .............................................212 iv Database Language SQL 8.5 .........................................229 9 Data assignment rules ........................................231 9.1 Retrieval assignment .......................................231 9.2 Store assignment ...........................................234 9.3 Set operation result data types ............................237 10 Additional common elements ...................................239 10.1 and ...252 11 Schema definition and manipulation ...........................255 11.1

28. SQL Server Home The onestop for developer information from the source about Microsoft sql Server. http://msdn.microsoft.com/sqlserver/

Microsoft.com Home Site Map MSDN Home Developer Centers ... MSDN Worldwide Search for All MSDN and KB All Library Code and Downloads Product Information Knowledge Base Advanced Search SQL Server Developer Center Data Access and Storage Developer Center Product Information ... MSDN Home SQL Server Home TechEd 2004 SQL Server Presentations Check out the PowerPoint presentations that have been posted from TechEd. Coverage includes T-SQL tips, Reporting Services development, security best practices, SQL Server 2005 features, and more. On-Demand Webcast: Microsoft SQL Server 2005 Overview SQL Server 2005 will provide organizations with next-generation capabilities in data management, developer productivity and business intelligence. Learn more about these enhancements in this webcast. Improving SQL Server Performance More... SQL Server 2005 Resources Programming Enhancements in SQL Server 2005 Powerful New T-SQL Syntax Gives SQL Server 2005 a Programmability Boost Managed UDTs Let You Extend the SQL Server Type System XML in SQL Server 2005: The Native XML Type and Advanced Data Handling ... Microsoft SQL Server 2005 Product Home Chats/Webcasts/Multimedia/Etc. Webcast 6/8: Global Business Process Automation with Siebel and Microsoft SQL Server - Level 200 See how Siebel scales on SQL Server. Microsoft’s Siebel implementation on SQL server, which supports Microsoft’s global sales and marketing group, will be used as an illustration. This system supports over 6,000 weekly users across over 50 subsidiaries where Microsoft does business.

29. XTG Systems Visual CASE tool for data structure modelling, reverse engineering of the database, generation of sql scripts, and HTML documentation of the model. http://www.xtgsystems.com/

30. Oracle - SQL And PL/SQL - Pal's Linux RDBMS Library Annotated links to free online readings http://www.palslib.com/Oracle/SQL_and_PLSQL.html

RDBMS-Independent Topics Fundamentals(75) SQL(22) ODBC(17) Web Access(11) ... Important Resources(25) RDBMSs Adabas D(16) Informix(58) Ingres II(64) InterBase(70) ... Sybase(42) Linux for Database Professionals Open Source Software(14) Introductions to Linux(12) The Kernel(13) Linux Administration(13) ... Feedback Oracle - SQL and PL/SQL SQL Added Oracle SQL FAQ Frank Naudé The SQL section of the Oracle FAQ. SQL for Web Nerds Philip Greenspun A very entertaining introduction to Oracle SQL. A Gentle Introduction to SQL Andrew Cumming An interactive SQL tutorial with access to real-world data through different database engines, including Oracle. An Incremental Approach to Developing SQL Queries Jonathan Gennick A methodology for writing SQL statements. An article from the July 2000 issue of Oracle Magazine Full Outer Joins in Oracle9i Sanjay Mishra An O'Reilly Network article on the new, ANSI-compliant outer join syntax in Oracle9i. Set Operations Sanjay Mishra, Alan Beaulieu On the UNION, MINUS, and INTERSECT operations. A sample chapter from the authors' book "Mastering Oracle SQL", published by O'Reilly. Doug Burns A tutorial on the DECODE function with examples.

31. SQL For Web Nerds 1998. sql for Web Nerds. by Philip Greenspun. Alex. philg@mit.edu Reader s Comments. A Gentle Introduction to sql offers an alternative perspective. http://philip.greenspun.com/sql/

SQL for Web Nerds by Philip Greenspun This is a draft manuscript. Comments (emailed to philg@mit.edu ) would be welcome. Preface Introduction Data modeling simple queries : one table, one table with subquery, JOIN, JOIN with subquery, OUTER JOIN more complex queries : GROUP BY, aggregates, HAVING Transactions (inserts and updates) triggers views style escaping to the procedural world : PL/SQL and Java executing inside the Oracle server trees handling dates in Oracle limits in Oracle; how they will bite you and how to work around them tuning , what to do when your query runs too slowly data warehousing , what to do when your query doesn't answer your questions foreign and legacy data , making foreign Web sites look like local SQL tables normalization Afterword Appendix A: Setting up your own RDBMS Appendix B: Getting real work done with Oracle More: the complete Oracle doc set is available online for registered (no charge) users, as a link from http://www.oracle.com/ ; some particularly interesting books are the Application Developer's Guide and Concepts Oracle 9i: The Complete Reference philg@mit.edu

32. UESQLC Project An embedded sql92 precompiler for C++ and Java, designed to be extensible using SGML documents. Open source, GPL http://www.uesqlc.org/

Introduction Documentation News Technical ... Spanish version ( Introduction UESQLC is an Open Source embedded SQL-92 precompiler for C++ and JAVA, designed to be extensible using SGML documents. It lets users access multiple relational database management systems from a single source program. Furthermore, it can verify the three levels of SQL conformance (Entry, Intermediate and Full). The distribution includes SGML documents that target Oracle Server OCI PostgreSQL LIBPQ PostgreSQL JDBC and ODBC database programming interfaces. UESQLC is distributed under the terms of the GNU General Public License (GPL) Documentation To build the documentation of both UESQLC and MPCL, you must use DOXYGEN , which will generate the documentation in PostScript, DVI, Man (Unix) and HTML formats. In the following pages you can find the HTML documentation for UESQLC and MPCL Technical UESQLC has been written in C++ using the MPCL library (see below). It was developed on Linux and it was tested on Linux (with PostgreSQL LIBPQ) and Sun Solaris (with Oracle Server OCI) but ports to other operating systems are welcome.

33. SQL Report Builder sql Report Builder with end user report designer. Free Delphi components. By T Software. http://www.nexus.hu/tungli/

The User directory you requested does not exist. www.nexus.hu /80/tungli

34. SQL Tutorial sql Tutorial and sql Reference. This sql tutorial aims to teach beginners the building blocks of sql. This is also a reference site for general sql commands. http://www.1keydata.com/sql/sql.html

SQL Tutorial SQL SELECT SQL DISTINCT SQL WHERE SQL AND OR ... HTML Tutorial Home SQL Commands Table Manipulation SQL Syntax SQL Tutorial Whether you are a beginner seeking SQL help, or a data warehousing veteran looking for a SQL refresher, you have come to the right place. This SQL tutorial site lists commonly-used SQL commands, and is divided into the following sections: SQL Commands : How SQL statements are used to store, retrieve, and manipulate data in the relational database. Table Manipulation : How SQL statements are used to manage tables inside the database. SQL Syntax : A single page that lists the syntax for all the SQL commands in this tutorial. For each command, the SQL syntax will first be presented and explained, followed by an example. By the end of this brief tutorial, you should have a good general understanding of the SQL syntax. In addition, you should be able to write SQL statements using the correct syntax to perform basic queries. My experience is that understanding the basics of SQL is much easier than mastering all the intricacies of this computer language, and I hope you will reach the same conclusion as well. Okay, enough introduction. Bookmark this site now by pressing

35. Contents Eine Anleitung zu sql, mysql und PHP, die auch auf die Zusammenh¤nge zwischen den Techniken eingeht. http://ffm.junetz.de/privat/reeg/DSP/node1.html

Next: 1 Vorwort Up: Datenbank, MySQL und PHP Previous: Datenbank, MySQL und PHP Contents 1 Vorwort 1 Vorwort 1 Aktuelle Version / Download 2 Was ist das hier oder was ist es nicht? ... Index Next: 1 Vorwort Up: Datenbank, MySQL und PHP Previous: Datenbank, MySQL und PHP Christoph Reeg http://reeg.net/

36. Hughes Technologies : The Home Of Mini SQL (mSQL) The official site for Hughes Technologies products including Mini sql (msql), ember, libhttpd, traffact, Lite, and W3msql. 19 May 2004 Mini sql 3.5 http://www.hughes.com.au/

mSQL 3.5 Released Version 3.5 of Mini SQL has been released. It includes some minor bug fixes and solutions for gcc version 3 compilation issues. Ember 1.7 Released The 1.7 release of Ember, which fixes some small bugs and compilation issue with gcc version 3 (Fedora, Debian sarge, FreeBSD 5.2 etc) is now available 19 May 2004 Mini SQL 3.5 Bug fixes and new features 3 Sep 2001 mSQL 2.0.12 Final 2.0 release 14 April 2004 Ember 1.7 Bug fixes and new features in this release 8 Jan 2003 TraffAcct 1.5 Minor bug fix 25 Nov 2002 LibHTTPD 1.3 Security update now available Mini SQL database OEM license application redistribution light weight embedded web server http library web server library http server httpd embedded scripting language embedded system develoment internet IP traffic monitoring billing ATM ethernet vpdn cisco SNMP ip acounting vlan Last updated 18 May 2004. Comments to webmaster@Hughes.com.au

37. Red Gate Consultants Ecommerce and Web Development,GUI and Client/Server Application Development, RDBMS Oracle, MS sql,Sybase. Design, installation, support and fine-tuning of mid to very large size relational database systems and data warehousing (OLAP) systems. http://www.redgate.net

Our company was founded in 1998 and provides Information Technology Services to businesses like yours. Our strong commitment to customer satisfaction and partner success is the cornerstone of our longevity. If the support and management of your information systems distracts you from your business focus then get to know RedGate Consultants by browsing through this web site. The concept of corporate integrated information system construction "RedGate Future Vision Enterprise Edition" Present concept is based on more common concept of Data Warehouse and is intended for the corporate companies, which have branch offices in many states of the USA. It reputes information repository development not as separate whole, but as a collection of all operational data warehouses (transactional systems) of your company, both already existing, and reputed. Designing system this way we avoid process of data collecting and reprojection of repository and system as a whole in case of variation or supplements of one of its subsystems, as this is a fundamental idea of present concept. Nucleus of present concept is a developed by our specialists universal relational data model, not depended from data domain, which it describes, and consequently the present concept has wide application in various branches of modern business.

38. Mini SQL : The MSQL Database System The official site for Hughes Technologies products including Mini sql (msql), ember, libhttpd, traffact, Lite, and W3msql. http://www.hughes.com.au/products/msql/

Mini SQL is our light-weight SQL Database engine technology. First developed in 1994, the release of mSQL 3 marks the third generation of the software. The generation 3 series provides new features that make mSQL even more suited to both large scale applications and resource constrained embedded environments. The second generation of our database technology has been incorporated into products from companies such as HP, Cisco, Tandem, Cray, EDS, TRW and Real Networks. We can't wait to see how people will use the third generation code. mSQL 3 mSQL 3.5 was release on 19 May 2004. You can download your copy here! The on-line manual is available in the Library Purchase mSQL You can purchase your mSQL license here Interested in redistributing mSQL with your product? Please contact us using info@Hughes.com.au Archive Previous releases of mSQL are available in the software archive Support Product support for Mini SQL is available from the mailing list. Info Details of specific releases can be found in the Release Notes . General info on the differences between mSQL 2 and mSQL 3 can be found in this document Mini SQL light weight relational database engine. OEM redistribution. mSQL client server. Embedded system applications.

39. CrossDB Standard Database Independent Api For Java An open source Java API for writing object oriented sql statements that will run on any database. Open source http://www.crossdb.com/

Documentation JavaDoc API Database Knowledge Base Contributors ... Home Supporters Companies Using crossdb: Fila USA United Diamond VacancyInfo.com Betchu.com Rejuveness cdnairports.com Get Involved Are you interested in helping bridge the gaps created by early corporate man. First thing to do is sign up to our mailing lists. Click here Welcome to CrossDB.com. If you are here for the first time then please take the time to understand what the CrossDB project is all about. If you feel you can contribute in any way then get in contact or simply get on our mailing lists News Jan. 7, 2004 - Planning for version started and is now being hosted at Java.net. April 11, 2003 - 1.0 RC2 Now available for download. News Archive What is CrossDB? crossdb is a standard Java™ API for writing object oriented SQL statements that are database independent. This means that you create SQL statement objects that will run on any database without having to change your code when moving to a different database. You can see some examples here Why would I use CrossDB?

40. SQLite Home Page sqlite An Embeddable sql Database Engine. This Introduction. sqlite is aC library that implements an embeddable sql database engine. Programs http://www.sqlite.org/

bugs changes cvs repository documentation ... wiki About SQLite SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include: ACID (Atomic, Consistent, Isolated, Durable) transactions. Zero-configuration - no setup or administration needed. Implements most of SQL92. ( Features not supported A complete database is stored in a single disk file. Database files can be freely shared between machines with different byte orders. Supports databases up to 2 terabytes (2^41 bytes) in size. Small memory footprint: less than 30K lines of C code, less than 250KB code space (gcc on i486) Faster than other popular database engines for most common operations. Simple, easy to use API TCL bindings included. Bindings for many other languages available separately. Well-commented source code with over 90% test coverage. Self-contained: no external dependencies. Sources are in the public domain . Use for any purpose. The SQLite distribution comes with a standalone command-line access program ( sqlite ) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

Page 2     21-40 of 191    Back | 1  | 2  | 3  | 4  | 5  | 6  | 7  | 8  | 9  | 10  | Next 20