E

EACH (reserved word), 466

Edit menu in Query Analyzer, 64

efficiency and primary keys, 6

Ellison, Larry (Oracle), 19

ELSE (reserved word), 461, 464

embedded SELECT statements, 280–283

ENCRYPT() function, 480

END (reserved word), 461

END-EXEC (reserved word), 464, 466

Enterprise Manager

opening, 50

overview, 50–51

SQL expression, modifying, 58–62

Entity Relationship Diagram (ERD), 15

EQUALS (reserved word), 466

ERRLVL (reserved word), 461

@@ERROR, 167–168, 204, 470

errors, handling and raising, 374–378

ESCAPE (reserved word), 461, 464

event-handling code, 403–404

EVERY (reserved word), 466

EXCEPT command, 453

EXCEPT (reserved word), 460, 464

EXCEPTION (reserved word), 464, 466

exclusive locks, 18

EXEC (reserved word), 460, 462

EXECUTE AS option, 344

EXECUTE (reserved word), 460, 462

executing query with Query Designer tool, 56

execution plan, 43

EXISTES (reserved word), 462

EXISTS() function, 288–289

EXISTS (reserved word), 460

EXIT (reserved word), 460

EXP() function, 193, 475

explicit transactions, 254, 273–276

expression, joining on an, 244–245

eXtensible Markup Language (XML)

overview, 412

procedures, 508

EXTERNAL (reserved word), 462, 466

external systems and extended procedures

xp_cmdshell, 490

xp_enumgroups, 490

xp_findnextmsg, 490

xp_grantlogin, 490

xp_logevent, 490

xp_loginconfig, 490

xp_logininfo, 490

xp_msver, 490

xp_revokelogin, 490

xp_sprintf, 491

xp_sqlmaint, 491

xp_sscanf, 491

EXTERNAL_LANGUAGE view, 516

EXTERNAL_NAME view, 516

EXTRACT (reserved word), 462