SQL Server 2000 Stored Procedures Handbook (Experts Voice)

reasons for preferring, 80

type of cursor, 68

FETCH statement

accessing cursors from code, 70

FROM clause, 71

INTO clause, 71, 72

position options, 71

syntax, 70

field formatting

formatting result set using cursors, 73

file system stored procedures, 161

XP_AvailableMedia system stored procedure, 161

XP_DirTree system stored procedure, 162

XP_FileExists system stored procedure, 163

XP_FixedDrives system stored procedure, 163

XP_ReadErrorLog system stored procedure, 164

XP_SubDirs system stored procedure, 162

fn_helpcollations function, 192

fn_listextendedproperty function, 192

fn_servershareddrives function, 192

fn_trace_geteventinfo function, 192

fn_trace_getfilterinfo function, 192

fn_trace_getinfo function, 192

fn_trace_gettable function, 192

fn_virtualfilestats function, 192

fn_virtualservernodes function, 192

FOR trigger, 206

replaced by AFTER trigger, 206

FOREIGN KEY constraints, 124

FORWARD_ONLY

direction for cursor, 68

FROM clause

FETCH statement, 71

full model

recovery model for database, 81