Accessing and Changing Relational Data
Table of contents
- Accessing and Changing Relational Data Overview
- Query Tools and Programming Interfaces
-
Transact-SQL Syntax Elements
- Using Identifiers
-
Using Data Types
- Using Binary Data
- Using char and varchar Data
- Using Date and Time Data
- Using Integer Data
- Using decimal, float, and real Data
- Using Monetary Data
- Using text and image Data
- Using uniqueidentifier Data
- Using Special Data
- Using Unicode Data
-
Data Type Conversion
- Moving Data to Program Variables
- Converting binary and varbinary Data
- Converting bit Data
- Converting Character Data
- Converting datetime and smalldatetime Data
- Converting float and real Data
- Converting money Data
- Converting decimal and numeric Data
- Data Type Conversions Using OLE Automation Stored Procedures
- Using Constants
- Using Functions
- Expressions
- Using Comments
- Using Reserved Keywords
- 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
- Using Partitioned Views
-
Subquery Fundamentals
- Subquery Rules
- Qualifying Column Names in Subqueries
-
Subquery Types
- Subqueries with Aliases
- Subqueries with IN
- Subqueries with NOT IN
- Subqueries in UPDATE, DELETE, and INSERT Statements
- Subqueries with Comparison Operators
- Comparison Operators Modified by ANY, SOME, or ALL
- Subqueries with EXISTS
- Subqueries with NOT EXISTS
- Using EXISTS and NOT EXISTS to Find Intersection and Difference
- Subqueries Used in Place of an Expression
- Multiple Levels of Nesting
- Correlated Subqueries
- Conditional Data Processing Using CASE
- Summarizing Data
- Error Handling
- Querying SQL Server System Catalogs
- Managing ntext, text, and image Data
- OLE Automation Objects in Transact-SQL
- Transact-SQL Tips
- Modifying Data
- Transactions
- Locking
- Cursors
-
Distributed Queries
- Accessing External Data
- External Data and Transact-SQL
- Collations in Distributed Queries
- Obtaining Meta Data from Linked Servers
- OLE DB Providers Tested with SQL Server
-
OLE DB Provider Reference for Distributed Queries
- OLE DB Objects Consumed by Distributed Queries
- Four-Part Name Requirements for OLE DB providers
- UPDATE and DELETE Requirements for OLE DB Providers
- INSERT Requirements for OLE DB Providers
- Keyset-Driven Cursors Requirements for OLE DB Providers
- Distribution Statistics Requirements for OLE DB Providers
- SQL Dialect Requirements for OLE DB Providers
-
Full-text Search
-
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 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
- Using Full-text Predicates to Query image Columns
- 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
-
Full-text Querying SQL Server Data