Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

federated servers, 244

alternative to, 255-256

Fetch statements, 96

flow-control statements, 77

Begin…End statements, 80-81

comments, 78-80

GoTo statements, 89-90

If statements, 81-86

WaitFor statements, 90

While statements, 86-89

four-part names, 54

full-text indexing and querying, 446-448

FullText Search, 5, 447

fully qualified names, 54

functions

aggregate, 132-134

as check and default constraints, 104

conversion, 115-118

date and time, 121-124

in expressions, 103

for handling identity values, 120-121

for handling null values, 113-115

instead of tables, 104-105

metadata, 131-132

as part of the selection criteria, 103

pass-through, 136-138

ranking, 134-136

returning current session information, 118-120

rowset, 136-142

scalar, 106-136

in selection and assignment, 102-103

side-effects, 306

string, 124-130

syntax, 102

table-valued, 104-105

user-defined, 304-314