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