Geometry.Net - the online learning center
Home  - Computer - Sql
e99.com Bookstore
  
Images 
Newsgroups
Page 8     141-160 of 194    Back | 1  | 2  | 3  | 4  | 5  | 6  | 7  | 8  | 9  | 10  | Next 20

         Sql:     more books (99)
  1. Joe Celko's SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko, 2006-10-05

141. Full Text Search On SQL 2000 Part 1
This article demonstrates using MS sql Full Text Search Engine to obtian web search sytle results by Don Schlichting.
http://www.databasejournal.com/features/mssql/article.php/3441981
Free Newsletters:
Database
Journal
DBA
News
Search Database Journal:
HOME
News MS SQL Oracle ...
FEATURES

RESOURCES
Products

Books

Scripts

Links
... FORUMS internet.commerce Be a Commerce Partner Web Hosts Online Colleges Shopping ... Vendors Plan SOA 'Maturity' Model internet.com Developer Downloads International Internet Lists ... LEAD, NEVER FOLLOW. DOWNLOAD INTEL® SOFTWARE INSIGHT. Prepare for today’s technologies and tomorrow’s innovations with Intel’s new series for technology leaders. Volume 1: Multi-Core Processing. December 2, 2004 Full Text Search on SQL 2000 Part 1 By Don Schlichting
Introduction
Full Text Searching is a free, optional component of MS SQL 2000. When installed, it offers a vast array of additional string querying abilities. Full Text Searching allows for string comparisons similar to internet search engines, returning both results and a matching score or weight. With regular TSQL, string matching is usually limited to an exact match, or a wildcard match with the keyword "LIKE." Full Text Searching exceeds this by searching for phrases, groups of words, words near one another, or different tenses of words, such as run, running, and ran. In addition, if Microsoft Office Word or Excel documents are saved in the database, their contents can be searched like a typical varchar field. Full Text Searching is accomplished by installing a new service (Microsoft Search), and using key words in TSQL designed specifically for text searching. This article will demonstrate installing, configuring and using the Full Text Search engine.

142. Oracle FAQ: SQL
Questions and answers about Oracle s implementation of sql (Structured Query Language).
http://www.orafaq.com/faqsql.htm
Index Search Add FAQ Ask Question
Oracle SQL FAQ
$Date: 09-Jun-2005 $
$Revision: 1.95 $
$Author:
Topics
  • What is SQL and where does it come from? What are the difference between DDL, DML and DCL commands? How does one escape characters when building SQL queries? How does one eliminate duplicate rows from a table? ...
  • Back to Oracle FAQ Index
    What is SQL and where does it come from?
    Structured Query Language (SQL) is a language that provides an interface to relational database systems. SQL was developed by IBM in the 1970s for use in System R, and is a de facto standard, as well as an ISO and ANSI standard. SQL is often pronounced SEQUEL. In common usage SQL also encompasses DML (Data Manipulation Language), for INSERTs, UPDATEs, DELETEs and DDL (Data Definition Language), used for creating and modifying tables and other database structures. The development of SQL is governed by standards. A major revision to the SQL standard was completed in 1992, called SQL2. SQL3 support object extensions and are (partially?) implemented in Oracle8 and 9.
  • Back to top of file
  • What are the difference between DDL, DML and DCL commands?

    143. NuPortalCity Hosting - SQL Server, MySQL - ASP.NET, ASP, PHP, Portals - Unlimite
    Supports ASP.NET, ASP, CGI, Perl and PHP. Features include sql Server 2000, Mysql database and unlimited bandwidth.
    http://www.nuportalcity.com/
    Unlimited Bandwidth
    ASP, ASP.NET, GCI, PHP, Perl
    MySQL, MS SQL Server 2000, Access
    E-Mail Account with Web Access
    FTP Accounts
    Static IP Address
    Full Domail Management
    Unlimited Domains and Sub Domains
    Dedicated Servers
    "NuDigital Solutions is dedicated in providing its customers with one of the most affordable and feature rich internet hosting services available. We've created NuPortal City in order to distinguish ourselves by offering products and services which are not normally included by other hosting providers."
    President NuDigital Solutions LLC Telephone and Online Help Desk More Extras Site Builder Wizard Ecommerce Wizard Testimonial Member Login Contact Us Support ... Privacy

    144. Oracle FAQ: PL/SQL
    Questions and answers about PL/sql, Oracle s procedural extention to standard sql.
    http://www.orafaq.com/faqplsql.htm
    Index Search Add FAQ Ask Question
    Oracle PL/SQL FAQ
    $Date: 09-Jun-2005 $
    $Revision: 2.08 $
    $Author:
    Topics
  • What is PL/SQL and what is it used for? Should one use PL/SQL or Java to code procedures and triggers? How can one see if somebody modified any code? How can one search PL/SQL code for a string/key value? ...
  • Back to Oracle FAQ Index
    What is PL/SQL and what is it used for?
    PL/SQL is Oracle's P rocedural L anguage extension to SQL . PL/SQL's language syntax, structure and data types are similar to that of ADA . The PL/SQL language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance). PL/SQL is commonly used to write data-centric programs to manipulate data in an Oracle database.
  • Back to top of file
  • Should one use PL/SQL or Java to code procedures and triggers?
    Internally the Oracle database supports two procedural languages, namely PL/SQL and Java. This leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour of Java?". Many Oracle applications are based on PL/SQL and it would be difficult of Oracle to ever desupport PL/SQL. In fact, all indications are that PL/SQL still has a bright future ahead of it. Many enhancements are still being made to PL/SQL. For example, Oracle 9iDB supports native compilation of Pl/SQL code to binaries.

    145. IronGrid, Inc
    IronEye sql A JDBC profiling tool that allows J2EE developers to identify database performance bottlenecks by viewing the sql that flows between an application and database through a GUI console with no code changes. IronEye Cache Leverages IronEye sql technology to enable intelligent, easy caching. Commercial
    http://www.irongrid.com/catalog/default.php

    146. Imceda.com - SQL Related Software Products And Design Tools
    Offers software for object development on the sql Server platform; backup andrecovery software; database sql profiling and analysis; database comparison
    http://www.imceda.com/
    Our Solutions Backup Software
    Disaster Recovery

    SQL Server

    Backup System
    ... Person Our Products LiteSpeed
    Free Trial

    Learn More

    FAQ's

    Demo
  • 90% reduction of backup storage costs
  • 75% reduction of backup and restore times
  • Increased performance
  • Increased security with encryption
  • SQL IDE
    Free Trial

    Learn More

    FAQ's
  • Speed code development
  • Store and share code
  • Ensure code accuracy and suitability
  • Coefficient Free Trial Learn More FAQ's
  • Advanced SQL analysis
  • See SQL impacting server performance
  • Reduce analysis of database activity
  • Save time and increase productivity
  • Change Manager Free Trial Learn More FAQ's
  • Compare selected objects in 2 databases
  • Display the differences
  • Generate change scripts
  • SQL Turbo SQL Turbo is a revolutionary search application which dramatically increases the speed of SQL Server's free text retrieval. It adds all the advanced search features you need in SQL Server for building a professional search application: Free Trial Learn More FAQ's
  • speed improvements of up to 100 times that of SQL Server's Full Text Catalogue
  • significantly increases SQL Server's ability to index and search text in large database tables
  • advanced search features (e.g. approximate search)
  • 147. Web Site Hosting - IIS, Coldfusion MX, ASP.NET, SQL Server
    Windows 2003 shared and sql Server 2000 Hosting. Domain registrations and ecommerce tools including SSL certificates. Located in Oregon.
    http://www.websitehosting.net
    Quick Links: ASP.NET Plans Miva Merchant Plans ColdFusion Plans Classic ASP Plans SQL 2000 Plans Current Special Offers: Free Domain Name with all sites Free Setup on Transferred Accounts Free Setup on Enterprise Accounts Rated:
    by Aspin.com users
    What do you think?
    5 Stars 4 Stars 3 Stars 2 Stars 1 Star

    148. SQL*XL: Oracle To Excel Bridge. Brings Database Access Native Into Excel.
    Adds a menu item to Excel through which sql can be submitted to Oracle. Full feateredand allows bulk inserts/updates, PL/sql, VBA.
    http://www.oraxcel.com/
    LIT
    software
    Order Software ... OrderForm home of SQL*XL - the bridge between Excel and all your databases. SQL*XL product page Products Order Downloads Support Company Profile Contact Us Portfolio Want to talk to us? We use
    Messenger! For questions,
    support and sales enquiries. .NET Messenger Service
    Get it here for free. In Messenger use "Add a Contact" : gjlinker@oraxcel.com
    Please note that this is not an email adddress you can email to.

    149. Server Colocation Service Provider Colocation Facility At Cybercon
    Specializes in dedicated Internet server hosting and in management services for Linux, Windows NT, FreeBSD, BSDI, and Solaris servers; Oracle, msql, Mysql, Postgresql and Microsoft sql database applications; C, C++, Java, Perl, PHP3, ASP and Cold Fusion programming.
    http://www.cybercon.com
    World-Class Internet Hosting Center
    Fri Sep 16, 2005 23:03:53
    Cybercon is a world-leading provider of data center infrastructure, eBusiness and IT services. We offer advanced and complex web hosting, data center server colocation, dedicated server hosting, disaster recovery, and managed eBusiness and IT services. Our tier 1 state-of-the-art Internet hosting center features multiple Gigabits premium Internet backbone connections. We offer a high level of expertise with network and server hardware, Unix and Windows operating systems, web, email, database, and eBusiness applications. - Cybercon launches its new Custom Support Portal. Cybercon's new Customer Support Portal provides many new features such as multi-user access, page level permission control, and more supporting tools for advanced services.
    - Millennium Digital Media offers Real Time Live Support to Customers using Livehelper. MSO provides live support via the web lowering costs and increasing customer satisfaction.
    - Cybercon launched WebMeeting online meeting and web conferencing services.
    more news
    Data Center Server Colocation
    Your equipment hosted in our state-of-the-art Internet data center: 24x7x365 on-site tech staff; direct, highly scalable and super fast connections to most of the top Internet backbones; power generator; UPS; cooling system; pre-action fire suppression system. Ideal solutions for server colocation, disaster recovery, data center and IT facility outsourcing.

    150. HSQLDB
    HsqlDB is the leading sql relational database engine written in Java. It has aJDBC driver and supports a rich subset of ANSI92 sql (BNF tree format) plus
    http://www.hsqldb.org/
    hsqldb - 100% Java Database
    Lightweight 100% Java SQL Database Engine downloads: With HSQLDB now part of OOo 2.0 Office Suite , there is an even stronger case for OpenOffice.org in government, education and enterprise. The third international OpenOffice.org Conference will be held this year from 28 to 30 September in Koper - Capodistria, Slovenia. This historic city is across the border from Trieste, Italy, with excellent transport links. Sponsors are needed for the Conference. OOoCon 2005 HSQLDB OpenOffice.org integration: OpenOffice.org users and user groups have made financial contributions towards the integration of HSQLDB with OOo. Your donations are still needed to reach the target. You can make a donation here commercial support: Commercial support for business users of HSQLDB is available from the HyperXtremeSQL web site. Buying support will help ensure the continued maintenance and development of HSQLDB. A new, higher-performance database engine based on HSQLDB is also available from that site. on the web: Talking about HSQLDB Congratulations to HSQLDB developer Justin Spadea on his graduation with High Honors from Rochester Institute of Technology. Justin wrote code to support multi-row INSERT and MERGE commands.

    151. HSQLDB
    RDBMS with JDBC interface, clientserver version, query tool, grid, tree, performance test class, servlet, and self-test program. Open Source, BSD-like
    http://hsqldb.sourceforge.net/
    hsqldb - 100% Java Database
    Lightweight 100% Java SQL Database Engine downloads: With HSQLDB now part of OOo 2.0 Office Suite , there is an even stronger case for OpenOffice.org in government, education and enterprise. The third international OpenOffice.org Conference will be held this year from 28 to 30 September in Koper - Capodistria, Slovenia. This historic city is across the border from Trieste, Italy, with excellent transport links. Sponsors are needed for the Conference. OOoCon 2005 HSQLDB OpenOffice.org integration: OpenOffice.org users and user groups have made financial contributions towards the integration of HSQLDB with OOo. Your donations are still needed to reach the target. You can make a donation here commercial support: Commercial support for business users of HSQLDB is available from the HyperXtremeSQL web site. Buying support will help ensure the continued maintenance and development of HSQLDB. A new, higher-performance database engine based on HSQLDB is also available from that site. on the web: Talking about HSQLDB Congratulations to HSQLDB developer Justin Spadea on his graduation with High Honors from Rochester Institute of Technology. Justin wrote code to support multi-row INSERT and MERGE commands.

    152. Comparing Two SQL Databases With AdeptSQL Diff
    Offers an IDE for creating and managing database schema from sql scripts, includingmacro preprocessor, syntaxoriented editor, schema decompiler and
    http://www.adeptsql.com/
    Your database comparison
    and synchronization tool Diff tool: Introduction Screenshots Order now Revision history Documentation ... Adept SQL Tools Diff tool Downloads Ordering Quotes FAQ ... Contact us
    Comparing SQL schema and table data with AdeptSQL Diff
    AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases. The program scans both databases and displays the combined schema tree view, with all differences color-marked. Navigating through the database schema tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side in the larger panel to the right of the schema tree. You can produce difference scripts for any chosen part or for the whole schema. The schema matching engine generates effective update SQL for any schema difference you need to synchronize, trying to preserve the table data whenever possible. The generated scripts are displayed in a separate debugger-style popup window where you can edit them, execute them either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors. AdeptSQL Diff a perfect tool to reverse-engineer your database schema.

    153. SQL Databases
    Linux sql Databases links by C.Browne.
    http://www.ntlug.org/~cbbrowne/rdbmssql.html
    Christopher B. Browne's Home Page cbbrowne@gmail.com Christopher Browne's Web Pages Prev Next
    3. SQL Databases
    There are more SQL database systems available for Linux than anyone would expect. Lots of commercial products; a surprising number of free SQL databases. Not much formal benchmarking such as TPC - Transaction Processing Performance Council has been done on Linux ; here are some comparisons that I am aware of:
    • MySQL contains some relative comparisons between various different database systems. This is presented at the MySQL AB web site, so it might well have certain biases... PostgreSQL vs MySQL discussion ... PostgreSQL vs MySQL: Which is better? Many of the commercial database vendors downright forbid the publication of comparative benchmarks, which makes it rather difficult to determine comparative performance. There is some fairness in this; squabbling between proponents of MySQL and PostgreSQL tends to take place when tests are presented. Benchmarks are almost always constructed in such a way as to favor the whichever database the benchmark-maker favors. Someone who prefers PostgreSQL is likely to construct benchmarks (and, for that matter, to use their database) in a manner that will favor

    154. Welcome To DdlUtils
    Commons sql is a component for working with databases and generating DDL. Commons sql contains a simple set of beans that represent a relational
    http://jakarta.apache.org/commons/sandbox/sql/
    /* */ @import "skin/tigris.css"; @import "skin/quirks.css"; @import "skin/inst.css"; /* */ Apache DB DdlUtils Search... The DdlUtils site The web for Home Section About Home Release Notes Todo ... Whole site as PDF Credits apache.org db ddlutils
    PDF
    Welcome to DdlUtils
    What is DdlUtils
    DdlUtils is a small, easy-to-use component for working with Database Definition (DDL) files. These are XML files that contain the definition of a database schema, e.g. tables and columns. These files can be fed into DdlUtils via its Ant task or programmatically in order to create the corresponding database or alter it so that it corresponds to the DDL. Likewise, DdlUtils can generate a DDL file for an existing database. DdlUtils uses the Turbine XML format, which is shared by Torque and OJB . This format expresses the database schema in a database-independent way by using JDBC datatypes instead of raw SQL datatypes which are inherently database specific. An example of such a file is:
    Learning more
    There are essentially two ways to use DdlUtils:
    • In an Ant build script via the task provided by DdlUtils. You can learn more about

    155. ShadoMX Content Management System
    Providers of Straker Shado Content Management System for Internet, Intranet and Extranet use. Build with ColdFusion, Windows 2000 and sql.
    http://www.straker.co.nz
    @import url(/strakercss/app_templates/stylesheets/nav.css); @import url(/strakercss/app_templates/stylesheets/home.css); Contact Us Support Login Search Site map ... Pricing STRAKER INTERACTIVE is a leading global provider of enterprise content management software. Our flagship product is the ShadoMX CMS, an enterprise content management system and web application framework. ShadoMX has a large number of success stories in the Travel and Tourism content management and Education content management sectors.
    Products
    ShadoMX
    Fully featured Enterprise Content Management System Portal Express
    • Macromedia Flex UI
    • LDAP integration
    • J2EE Portal
    • Rapid deployment
    Success Stories
    Tourism New Zealand
    View Case Study >>
    Auckland University
    View Case Study >>
    Education Content Management
    • Single sign-on
    • Cluster ready
    • XML based content
    • W3C Compliant
    Tourism Content Management
    • Destination management software
    • Multi-language CMS
    • User profiling and personalization
    • Image and digital asset library
    Intranet Pack
    • Content Management
    • Vacancies Module
    • Event Calendar
    • Online Poll
    • Simple Form Builder
    • News Module
    News
    ShadoMX Powered London Met website Rated No.1 UK University Website

    156. Learn SQL Tutorial
    sql Structured Query LanguageTutorial covering basics of sql Language.
    http://www.bitesizeinc.net/index.php/sql.html
    HOT
    BiteSizeInc.Net Expanded
    LEARN
    About BiteSize - Telecommuting Consultants Bite Size Products and Services Bite Size Downloads Contact Bite Size
    HELP
    Quick Answers Computer Advice Free Software Learn SQL Tutorial 'How To' Pages BOLT User Manual Question Board Emergency Assistance ... Disaster Recovery Using Telework Technology
    RELAX
    Online Scavenger Hunt - Real Prizes ! Repeat after Simon Some Tic Tac Toe Ouija Online - Artificial Intelligence Ouija Board Voodoo Online - Virtual Voodoo Doll ... eScene Virtual Sticker Board
    Learn SQL Tutorial
    Recommend this page friend's
    email
    Learn SQL tutorial >
    We've Upgraded - Visit the Expanded Home Page Learning SQL Tutorial Home SQL - Structured Query Language. It is an orderly question format for getting data in and out of a file. And it is fast. Looking for a way to make your software networkable ? Tired of writing functions for searching for information in a text file ? Want to write some database driven web pages ? Some Access Queries ?
    Here you can learn the basics about SQL. We recommend MySQL as a great program for learning this. It's not fancy to look at, but once you see the power of SQL, you'll see why it doesn't need to be. There are a ton of tools in a lot of languages for MySQL. And if this tutorial gets you interested, there is more detailed information at the

    157. Armadillonet
    Provides domain name registration, web hosting, dedicated servers, and colocation services with ASP.NET, Coldfusion, PHP, and sql.
    http://www.armadillonet.com
    HOSTING ABOUT US CONTACT US QUICK LINKS
    Welcome to ArmadilloNet Web Hosting!
    ArmadilloNet provides hosting solutions with superior customer service at an affordable price. We offer scalable website, application, e-commerce, blog and database hosting solutions.
    Available services include:
    • Dedicated and co-location web hosting
    • Shared hosting for Unix/Linux and Windows platforms
    • MS-SQL / application support
    • List-servs, mailing lists and bulletin boards
    • E-commerce packages
    • Blogs and more...
    Quick links: PO Box 5633 Takoma Park, MD 20913 / 1-877-303-8905 ArmadilloNet Web Hosting is a subsidiary of Three Gems Inc. in Washington DC

    158. Sql Tutorial - Free Sql Tutorial - Online Tutorial Sql - Sql Server Tutorial
    sql tutorial free sql tutorial - online tutorial sql - sql server tutorial atwebdevelopersnotes.com.
    http://www.webdevelopersnotes.com/tutorials/sql/index.php3
    sql tutorial - free sql tutorial - online tutorial sql - sql server tutorial
    sql tutorial - free sql tutorial - online tutorial sql - sql server tutorial Home Basics Tutorials Web Design Templates ... MySQL guide - Last Words sql tutorial - free sql tutorial - online tutorial sql - sql server tutorial Homepage Tutorials SQL (MySQL)
    SQL Tutorial
    Welcome to the online free SQL tutorial at webdevelopersnotes.com What is SQL?
    The S tructured Q uery L anguage is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be extracted, sorted, updated, deleted and inserted. SQL has the full support of ANSI (American National Standards Institute), which has laid down certain rules for the language.
    SQL can be used with any RDBMS such as MySQL, mSQL, PostgresSQL, Oracle, Microsoft SQL Server, Access, Sybase, Ingres etc. All the important and common SQL statements are supported by these RDBMS, however, each has its own set of proprietary statements and extensions.
    The SQL tutorial on webdevelopersnotes.com

    159. ColdFusion Shopping Cart Cold Fusion Shopping Cart Small Business ECommerce Solu
    ColdFusion application which can be used with database engines in Access, MS sql Server or Mysql. Standalone purchase or free with hosting.
    http://www.cf-ezcart.com/
    ColdFusion Shopping Cart - Enterprise Level Shopping Cart at an Entry Level Price!
    Making B2C eCommerce and B2B eCommerce Affordable Home Shopping Cart Features cf_ezcart Demo Live Customer Store Fronts ... Contact Us Welcome! Login Here! Your Demo Shopping Cart Is Empty MERCHANT ACCOUNTS
    CREDIT CARD PAYMENT GATEWAYS cf_ezcart is 100% compatible with and approved by authorize.net, the Internet's leading real time credit card processor. To learn more about Authorize.net or to apply for a merchant account... CLICK HERE cf_ezcart also supports several other ecommerce payment gateway providers, and PayPal . To see if your real time processor is supported, click here . We highly recommend Authorize.net for proven secure, unlimited online payment transactions available in multiple currencies. Authorize.net's real-time credit card processing works on any server running ColdFusion, without the need for additional software installation.
    cf_ezcart ColdFusion Shopping Cart Application
    Version 9.6.2

    160. SQL And The Macintosh
    A port of the Mysql client APIs to MacOS. Also available is a driver for msql.
    http://www.lilback.com/macsql/
    SQL and the Macintosh
    This page hasn't been updated since 1999 or so. I'll be updating it real soon. This page is devoted to information about using SQL databases on the Macintosh, particularly the application and drivers I have written to talk to mSQL and MySQL databases. Contents:
    State of SQL on the Macintosh
    The state of SQL on the Macintosh is pretty good right now. Drivers are hard to come by, but the Merant ODBC Driver Manager and drivers are available . While there is no SDK to create ODBC drivers, drivers do exist for most of the major database products. An older driver manager is also available from Open Link Both company's products work on MacOS 8/9 and Merant has announced support for MacOS X. Oracle has native 7.3 drivers available for the MacOS, but you'll find no information about them anywhere on their website. If you'd like to get a copy, contact your Oracle representative and ask for part Z23078-01. Sybase and Pervasive both have native and ODBC drivers available, too. Other products that work on the Mac include

    Page 8     141-160 of 194    Back | 1  | 2  | 3  | 4  | 5  | 6  | 7  | 8  | 9  | 10  | Next 20

    free hit counter