This module contained many of the important topics needed to use SQL Server 2000 on a daily basis when inserting data.
In addition, it contains much of the information that is relevant to passing the 70-029 Microsoft exam. Having completed this module, you should be ableto:
- Use literal values in your
UPDATE queries to modify a table using values from another table
DELETE statements using subqueries
- Optimize your
This module introduced you to the following terms:
- Literal value: A value that is actually specified in Transact-SQL code and not stored in a variable or table.
Examples of literal values include "free", "[email protected]", 72, and 1283. Literal values that store character data are called string literals and are always enclosed in quotations.
- Query plan: The method that SQL Server uses to access data in the fastest possible way.
- Query optimizer: The query optimizer is a part of the SQL Server engine, and determines the best way for SQL Server to execute a query. For example, it determines which index to use when executing a query.
- Table scan: The Query Optimizer reads the complete contents of a table, instead of using an index.
In the next module, you will learn how to implement full-text searching.