elements, XML, 509, 511–512
ELEMENTS mode, 516
ELEMENTS parameter, XML, 470
ELSE (IF…ELSE) function, 577
e-mail, 89–93
embedded quotation marks, 291
emergency restore, 183
empty constants, 298
empty elements, XML, 512
empty strings, T-SQL, 291
ENABLE TRIGGER function, 577
ENCRYPTBY function, 577
encryption, 277, 383, 406–408
END (BEGIN…END) function, 577
END CONVERSATION function, 577
end tags, 511
Endpoints, SOAP, 529–530
enterprise networks, 7–8
enterprise resource planning (ERP), 7
entity integrity, 360–361
Enumerations feature, CLS, 335
envelopes, SOAP message, 528
equal (=) operator, 296, 297, 462
Equal (=) operator, 560
ERP (enterprise resource planning), 7
ERROR function, 577
error handling process, Try…Catch support, 328
error logs, 496, 533–534
errors, mirror, 249–250
errors in models, 356–357
escape_character expression, 462
ETL (Extract, Transform and Load) packages, 17, 88
evaluation mechanisms, triggers as, 380–381
EVENT DATA function, 577
event tracing, 540
events, SQL Server Agent, 88
Events feature, CLS, 335
Everyone group, OS environment, 121
evidence-based security, 350
exact numerics data types, 301–302
EXCEPT function, 577
exception handling, 335, 351
Exceptions feature, CLS, 335
exclusive (X) locks, 492, 494
Exclusive OR (^) operator, Bitwise, 296
executable code, 56, 339
executable files, 344
EXECUTE AS function, 577
EXECUTE function, 577
Execute Queries, 409
EXECUTE statements, 410, 417, 429
execution
assemblies as units of, 348–349
managed and side-by-side, 339–340
execution plans, 66, 68, 70–71
EXISTS function, 298, 577
EXP function, 318, 577
explicit casting, 321–324
explicit distributed transactions, 503
EXPLICIT mode, 470, 515–516
explicit transactions mode, 500–501
Explorer, Windows, 24–25
exponential notation, 324
expression placeholder, 468
expressions, 577
LOWER(string) function, 313–314
nested, 299
T-SQL, 294–295
expropriated data, 489
extended properties, 38
extended stored procedures (XPs), 13, 401
extensible XML documents, 512
extensions, file, 41
extent locks, 491
extents, 40
external backup facilities, 188, 193
external database level, 21–22
Extract, Transform and Load (ETL) packages, 17, 88