F

FALSE (reserved word), 462, 466

federated views, 360–363

federating data, 249–250

FETCH NEXT statement, 297–298

FETCH (reserved word), 460, 462

@@FETCH_STATUS, 176, 469

fields, adding, 430–431

fifth normal form, 33

File menu in Query Analyzer, 64

FILE (reserved word), 460

file-based database products compared to relational database management system (RDBMS), 26

FILE_ID() function, 195, 476

FILE_NAME() function, 195, 476

FILLFACTOR (reserved word), 460

filtering rows, 137

filtering techniques, extended, 144–145

filtering updates, 264–266

FIND (reserved word), 464

first normal form — 1NF, 32

FIRST (reserved word), 462, 466

FLOAT (reserved word), 462, 466

FLOOR() function, 193, 475

fn_Get_SQL() function, 480

fn_HelpCollations() function, 480

fn_helpcollations() function, 200

fn_listextendedproperty() function, 195

fn_ServerSharedDrives() function, 480

fn_servershareddrives() function, 200

fn_trace_geteventinfo() function, 199, 478

fn_trace_getfilterinfo() function, 199, 478

fn_trace_getinfo() function, 199, 478

fn_trace_gettable() function, 199, 478

fn_VirtualFileStats() function, 480

fn_virtualfilestats() function, 201, 482

FOR clause, 454

FOR (reserved word), 460, 462

foreign key constraints

naming, 324

overview, 334–336

foreign keys, 30

FOREIGN (reserved word), 460, 462

format properties, setting, 431

FORMATMESSAGE() function, 201, 480

FORTRAN (reserved word), 462

FOUND (reserved word), 462, 464

fourth normal form, 32–33

FREE (reserved word), 464

free-form text indexing, 301

FREETEXT predicate, 318

FREETEXT (reserved word), 460

FREETEXTTABLE predicate, 319–320

FREETEXTTABLE (reserved word), 460

FROM clause, joining tables in, 234–235

FROM command, 451–452

FROM (reserved word), 460, 462

full joins, 241–243

full outer joins, 241–243

FULL (reserved word), 460, 462

full-text index queries

AND operator, 319

catalogs, managing and populating, 304–313

CONTAINS predicate, 314–317

CONTAINSTABLE predicate, 317–318

double quotes, 313

FREETEXT predicate, 318

FREETEXTTABLE predicate, 319–320

full-text query expressions, 313–320

logical operators, 319

Microsoft Search Service, 302–304

NEAR operator, 319

OR operator, 319

overview, 313

ranked results, 317

single quotes, 313

SQL Server 2000, 305–306

SQL Server 2005, 307–313

weighting values, 317

full-text index/search procedures

sp_fulltext_catalog, 491

sp_fulltext_column, 491

sp_fulltext_database, 491

sp_fulltext_service, 491

sp_fulltext_table, 491

sp_help_fulltext_catalogs, 491

sp_help_fulltext_catalogs_cursor, 491

sp_help_fulltext_columns, 491

sp_help_fulltext_columns_cursor, 491

sp_help_fulltext_tables, 491

sp_help_fulltext_tables_cursor, 491

full-text query expressions

AND operator, 319

CONTAINS predicate, 314–317

CONTAINSTABLE predicate, 317–318

double quotes, 313

FREETEXT predicate, 318

FREETEXTTABLE predicate, 319–320

logical operators, 319

NEAR operator, 319

OR operator, 319

overview, 313

ranked results, 317

single quotes, 313

weighting values, 317

FULLTEXTCATALOGPROPERTY() function, 195, 477

FULLTEXTSERVICEPROPERTY() function, 195, 477

FUNCTION (reserved word), 460

functions

aggregate functions, 164–167

arguments, 161

categories of, 160

conversion functions, 169–181

CONVERT () function, 161

cursor functions and variables, 175–176

date functions, 176–181

deterministic functions, 161–162

image/text functions, 192

mathematical functions, 192–193

metadata functions, 193–196

naming, 324

nested functions, 164

nondeterministic functions, 161–162

overview, 160–161

queries, used in, 163

ranking functions, 196–199

security functions, 199–200

SELECT statement used to assign variables, 163

SET statement used to assign variables, 162–163

string manipulation functions, 181–192

system functions and variables, 200–204

system statistical functions and variables, 204

variables used with, 162–163

future reserved words, 464–466