Index_B

B

backslash (\), 356

Backus-Naur Form. See BNF

bank

ATM withdrawal operation, 217–218

security standard, 452

batch mode, 681–683

BETWEEN expression and expression logical operator, 373–375

BETWEEN operator, 256

BFILE, SQL data type, 74

biggest orders, 344

binary data

encrypting, 443

read-only access, 74

binary instructions, executing, 528

binary numbers

converting to decimal, 773

storing bytes and bits, 44

binary strings

DB2 UDB 8.1, 52

described, 44, 51

MS SQL Server 2000, 52–53

Oracle 9i, 52

SQL99, 52

bits

length of expression, 308

storing, 44, 52, 74

bitwise operators

AND (&), 390

exclusive OR (/\), 390–392

NOT (~), 383, 390

OR (|), 390

blank spaces, removing from strings (TRIM, LTRIM, and RTRIM), 327–328

BLOB (binary, nonstructured objects)

described, 52

encrypting, 443

block structure, procedural language, key elements, 491–493

BNF (Backus-Naur Form)

DCL statements, 731

DDL statements

indexes, 729

schemas, 729–730

stored procedures, 730

tables, 728–729

triggers, 731

user-defined functions, 730

views, 729

described, 727–728

DML statements, 731–732

DQL statements, 732–734

book, recommended, Oracle Administration and Management (Michael Ault), 209

books, storing. See CLOB

Boolean expressions

complement or inverter (NOT), 775

described, 774–775

exclusive sum (XOR), 776

identities, 778–779

inverse product (NAND), 776–777

inverse sum (NOR), 777

negating (NOT), 381–382

precedence, 777–778

product (AND), 381, 775

SQL data types, 73

sum (OR), 775–776

Borland database, 130

brackets (()), 198

BS7799 security standard, 451

B-Tree indexes, 106, 108

business rules

ACME sample database, 613–614

archiving complex, 185

minimum and maximum order amount, discounts, 284–286

security through stored procedures, 440

table structure, changing, 145

values, changing, 285

byte

checking number, 357

storing, 44, 309




SQL Bible
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208

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