E


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




Microsoft SQL Server 2005. The Complete Reference
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
Year: 2006
Pages: 239

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net