A column in a table that has been assigned the identity property. The identity property generates unique numbers.
IIS
Microsoft Internet Information Server.
IN operator
The operator that compares a single value to a set, and returns true if the single value occurs within the set.
index
In a relational database, a database object that provides fast access to data in the rows of a table, based on key values. Indexes can also enforce uniqueness on the rows in a table. SQL Server supports clustered and non-clustered indexes. The primary key/unique constraint automatically causes an index to be built. In full-text searches, a full-text index stores information about significant words and their location within a given column.
Index Tuning wizard
A graphical tool that enables you to select and create powerful indexes and statistics for a Microsoft SQL Server 2000 database without prior knowledge of index and database internal structural designs.
indexed view
A view that has an index defined onto it. Indexes on views enable view resultsets to be stored in the database's physical storage after an index is created. In contrast to this, in a non-indexed view, the view is activated at runtime and the resultset is dynamically built.
INSERT
T-SQL command used to add one or more records to a table.
INSERT INTO
The INSERT INTO T-SQL statement can be used to insert rows of data into a table when needed.
INSERT trigger
FOR or AFTER triggers that can be used to verify the data being inserted or to perform any other action with the data. They fire automatically when an INSERT statement is made against the underlying table.
INSTEAD OF trigger
A trigger new to SQL Server 2000, which replaces the action that an INSERT, DELETE, or UPDATE trigger might take.
Internet host name (DNS name)
Fully qualified name that is associated with the computer on the Internet (for example, mycomputer.mydomain.com).