Index

T

table constraints CREATE TABLE statement
table list : FROM clause FROM clause
table number SYSTABLE system table
table size : limit Size and number limitations
table size : number of rows Size and number limitations
tables : about CREATE TABLE statement
tables : altering ALTER TABLE statement
tables : creating CREATE TABLE statement
tables : creating proxy CREATE EXISTING TABLE statement
Tables : creating proxy CREATE EXTERNLOGIN statement
tables : deleting all rows from TRUNCATE TABLE statement
tables : dropping DROP statement
tables : GLOBAL TEMPORARY CREATE TABLE statement
tables : loading LOAD TABLE statement
tables : renaming ALTER TABLE statement
tables : replicating ALTER TABLE statement
tables : temporary DECLARE LOCAL TEMPORARY TABLE statement
tables : truncating TRUNCATE TABLE statement
tables : unloading UNLOAD TABLE statement
tables : validating VALIDATE TABLE statement
TAN function TAN function [Numeric]
TaskSwitch property Connection properties
TaskSwitchCheck property Connection properties
TCP/IP : server configuration Network communications parameters
TCP/IP : server port number SERVERPORT parameter [ PORT]
tcpip : about - x command-line option
TDS communication parameter TDS parameter
temporary file : location TEMP environment variable
temporary tables : creating CREATE TABLE statement
temporary tables : declaring DECLARE LOCAL TEMPORARY TABLE statement
temporary tables : GLOBAL CREATE TABLE statement
temporary tables : LOCAL DECLARE LOCAL TEMPORARY TABLE statement
temporary tables : Transact-SQL CREATE TABLE statement
TEXT data type : about TEXT data type [Character]
TEXT file format OUTPUT_FORMAT option [ISQL
text functions Text and image functions
TEXTPTR function TEXTPTR function [String]
TEXTSIZE option Transact-SQLcompatibility options
TEXTSIZE option
THEN : IF expression IF expressions
thread count : database option THREAD_COUNT option
threads : execution -gn command-line option
threads : multiple processors -gt command-line option
threads : number of -gx command-line option
THREADS communication parameter THREADS parameter
THREADSTATS communication parameter THREADSTATS parameter [STATS]
THREAD_COUNT option General database options
THREAD_COUNT option
three-valued logic : about Three-valued logic
three-valued logic : NULL value NULL value
time data type Sending dates and times to the database
TIME data type : about TIME data type [Date and Time]
time format : database option TIME_FORMAT option
TIMEOUT communication parameter TIMEOUT parameter [TO]
times : comparing Date and time comparisons
times : queries Retrieving dates and times from the database
timestamp : DEFAULT_TIMESTAMP_INCREMENT option DEFAULT_TIMESTAMP_INCREMENT option
timestamp : timestamp columns AUTOMATIC_TIMESTAMP option
timestamp data type Sending dates and times to the database
TIMESTAMP data type : about TIMESTAMP data type [Date and Time]
timestamp format : database option TIMESTAMP_FORMAT option
TIMESTAMP_FORMAT option TIMESTAMP_FORMAT option
TIME_FORMAT option General database options
TIME_FORMAT option
TINYINT data type : about TINYINT data type [Numeric]
TMP, TEMP, and TMPDIR environment variable TEMP environment variable
TO communication parameter TIMEOUT parameter [TO]
TODAY function TODAY function [Date and time]
DUMMY system table
TRACEBACK function TRACEBACK function [Miscellaneous]
trademark information : retrieving xp_msver system function
Transact-SQL : ALLOW_NULLS_BY_DEFAULT option ALLOW_NULLS_BY_DEFAULT option
Transact-SQL : AUTOMATIC_TIMESTAMP option AUTOMATIC_TIMESTAMP option
Transact-SQL : bit data type compatibility Bit data type
Transact-SQL : bitwise operators Bitwise operators
Transact-SQL : catalog procedures Adaptive Server Enterprise catalog procedures
Transact-SQL : column NULLs compatibility ALLOW_NULLS_BY_DEFAULT option
QUOTED_IDENTIFIER option
Transact-SQL : COMMIT COMMIT TRANSACTION statement [T-SQL]
Transact-SQL : comparison conditions Comparison conditions
Transact-SQL : compatibility options Transact-SQLcompatibility options
Transact-SQL : constants Compatibility of expressions
Transact-SQL : CREATE MESSAGE CREATE MESSAGE statement [T-SQL]
Transact-SQL : CREATE PROCEDURE statement CREATE PROCEDURE statement [T-SQL]
Transact-SQL : CREATE SCHEMA statement CREATE SCHEMA statement
Transact-SQL : CREATE TABLE statement CREATE TABLE statement
Transact-SQL : database options SET statement [T-SQL]
Transact-SQL : DECLARE section BEGIN... END statement
Transact-SQL : delete permissions ANSI_PERMISSIONS option
Transact-SQL : error handling in RAISERROR statement [T-SQL]
Transact-SQL : executing stored procedures EXECUTE statement [T-SQL]
Transact-SQL : expressions Compatibility of expressions
Transact-SQL : global variables Global variables
Transact-SQL : local variables Local variables
Transact-SQL : money data types Money data types
Transact-SQL : NULL behavior ANSINULL option
Transact-SQL : outer join operators Join operators
Transact-SQL : procedures CREATE PROCEDURE statement [T-SQL]
Transact-SQL : QUOTED_IDENTIFIER option QUOTED_IDENTIFIER option
Transact-SQL : READTEXT statement READTEXT statement [T-SQL]
Transact-SQL : SET statement SET statement [T-SQL]
Transact-SQL : strings Compatibility of expressions
Transact-SQL : system catalog Views for Transact-SQL Compatibility
Transact-SQL : system functions Connection properties
Transact-SQL : system procedures Adaptive Server Enterprise system and catalog procedures
Adaptive Server Enterprise system procedures
Transact-SQL : update permissions ANSI_PERMISSIONS option
Transact-SQL : user-defined data types User-defined data types
Transact-SQL : WRITETEXT statement WRITETEXT statement [T-SQL]
transaction log : allocating space ALTER DBSPACE statement
transaction log : DBLOG The DBLOG command-line utility
Transaction log utility options
transaction log : delete after checkpoint - m command-line option
transaction log : erasing The Erase utility
transaction log : translation utilities The DBTRAN command-line utility
transaction log : translation utility The Log Translation utility
transaction log : TRUNCATE TABLE statement TRUNCATE TABLE statement
transaction log : utilities The DBLOG command-line utility
transaction log : utility The Transaction Log utility
transaction management COMMIT statement
COMMIT TRANSACTION statement [T-SQL]
transaction management : BEGIN TRANSACTION statement BEGIN TRANSACTION statement
transaction management : in Transact-SQL BEGIN TRANSACTION statement
COMMIT TRANSACTION statement [T-SQL]
transaction modes : chained CHAINED option
BEGIN TRANSACTION statement
transaction modes : unchained CHAINED option
BEGIN TRANSACTION statement
transactions : closing cursors CLOSE_ON_ENDTRANS option
transactions : COMMIT statement COMMIT statement
transactions : committing COMMIT statement
transactions : ROLLBACK statement ROLLBACK statement
transactions : ROLLBACK TO SAVEPOINT statement ROLLBACK TO SAVEPOINT statement
transactions : SAVEPOINT statement SAVEPOINT statement
TriggerPages property Properties available for the server
triggers : altering ALTER TRIGGER statement
triggers : and referential integrity actions RI_Trigger_time option
triggers : and replication FIRE_TRIGGERS option
triggers : creating Transact-SQL CREATE TRIGGER statement [T-SQL]
triggers : disabling -gf command-line option
triggers : dropping DROP statement
triggers : ROLLBACK statement ROLLBACK TRIGGER statement
triggers : TRUNCATE TABLE statement TRUNCATE TABLE statement
triggers : Watcom-SQL CREATE TRIGGER statement
TRIM function TRIM function [String]
TRUNCATE function "TRUNCATE" function [Numeric]
TRUNCATE TABLE statement : syntax TRUNCATE TABLE statement
Truncation : of character strings STRING_RTRUNCATION option
truncation length : Interactive SQL option TRUNCATION_LENGTH option [ISQL
TRUNCNUM function TRUNCNUM function [Numeric]
tsequal Adaptive Server Enterprise function Connection properties
TSQL_HEX_CONSTANT option TSQL_HEX_CONSTANT option
TSQL_VARIABLES option TSQL_VARIABLES option
two-phase commit : PREPARE TO COMMIT statement PREPARE TO COMMIT statement
type conversions Data type conversions
types : about data types CHAPTER 7. SQL Data Types