• ▼MSDN Library - April 2000
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio 6.0 Documentation
  • ▶Office Developer Documentation
  • ▶Windows CE Documentation
  • ▼Platform SDK
    • ▶Getting Started
    • ▶Design Strategies and Standards
    • ▶Base Services
    • ▶Component Services
    • ▼Data Access Services
      • ▶Microsoft Data Access Components (MDAC) SDK
      • ▶Jet and Replication Objects
      • ▶Microsoft XML SDK
      • ▼Microsoft SQL Server Programmer's Toolkit
        • ▶Getting Started
        • ▶What's New
        • ▶Installing SQL Server
        • ▶SQL Server Architecture
        • ▶Administering SQL Server
        • ▶Creating and Maintaining Databases
        • ▼Accessing and Changing Data
          • Overview of Accessing and Changing Data
          • ▶Query Tools and Programming Interfaces
          • ▶Transact-SQL Syntax Elements
          • ▶Accessing and Changing Data Fundamentals
          • ▶Query Fundamentals
          • ▼Advanced Query Concepts
            • ▶Using Aggregate Functions in the Select List
            • ▶Grouping Rows with GROUP BY
            • ▶Combining Results with UNION
            • ▶Subquery Fundamentals
            • Conditional Data Processing Using CASE
            • ▶Summarizing Data
            • ▶Error Handling
            • Querying SQL Server System Catalogs
            • ▶Managing ntext, text, and image Data
            • ▼Full-text Querying SQL Server Data
              • Full-text Index and Querying Concepts
              • Implementation of Full-text Search
              • Full-text Query Transact-SQL Components
              • ▼Using the CONTAINS Predicate
                • Searching for Specific Words or Phrases (Simple Term)
                • Combining Full-text Search Operators Using AND, OR, and NOT
                • Searching for Multiple Forms of Words or Phrases (Prefix Term)
                • Searching for Any Form of a Specific Word (Generation Term)
                • Searching for Words or Phrases Using Weighted Values (Weighted Term)
                • Searching for Words or Phrases Close to Another Word or Phrase (Proximity Term)
              • Using the FREETEXT Predicate
              • Combining Full-text Predicates with Other Transact-SQL Predicates
              • Using the CONTAINSTABLE and FREETEXTTABLE Rowset-valued Functions
              • Using Transact-SQL Functions to Obtain Full-text Property Values
              • Example of Combining Full-text Administration and Full-text Query
            • ▶Full-text Querying of File Data
            • ▶Distributed Queries
            • ▶OLE Automation Objects in Transact-SQL
            • ▶Solutions to Common Query Puzzles
            • ▶Transact-SQL Tips
          • ▶Adding Data
          • ▶Changing Data
          • ▶Deleting Data
          • ▶Transactions
          • ▶Cursors
          • ▶Locking
        • ▶Optimizing Database Performance
        • ▶Replication
        • ▶Data Transformation Services
        • ▶OLAP Services
        • ▶English Query
        • ▶Repository
        • ▶Building SQL Server Applications
        • ▶Troubleshooting
        • ▶How To
        • ▶Glossary
    • ▶Graphics and Multimedia Services
    • ▶Management Services
    • ▶Messaging and Collaboration Services
    • ▶Networking and Directory Services
    • ▶Security
    • ▶Tools and Languages
    • ▶User Interface Services
    • ▶Web Services
    • ▶Win32 API
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Specifications
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Samples