M

mail procedures

sp_send_dbmail, 493

sysmail_add_account_sp, 493

sysmail_add_principalprofile_sp, 493

sysmail_add_profileaccount_sp, 493

sysmail_add_profile_sp, 493

sysmail_configure_sp, 493

sysmail_delete_account_sp, 493

sysmail_delete_principalprofile_sp, 493

sysmail_delete_profileaccount_sp, 493

sysmail_delete_profile_sp, 493

sysmail_help_account_sp, 493

sysmail_help_configure_sp, 493

sysmail_help_principalprofile_sp, 493

sysmail_help_profileaccount_sp, 493

sysmail_help_profile_sp, 493

sysmail_start_sp, 493

sysmail_stop_sp, 493

sysmail_update_account_sp, 493

sysmail_update_principalprofile_sp, 493

sysmail_update_profileaccount_sp, 493

sysmail_update_profile_sp, 493

xp_readmail, 493

xp_sendmail, 493

many-to-many relationships, 15

MAP (reserved word), 465

MATCH (reserved word), 463, 465

MATCH_OPTION view, 514

mathematical functions

ABS() function, 193, 475

ACOS() function, 193, 475

ASIN() function, 193, 475

ATAN() function, 193, 475

ATN2() function, 193, 475

CEILING() function, 193, 475

COS() function, 193, 475

COT() function, 193, 475

DEGREES() function, 193, 475

EXP() function, 193, 475

FLOOR() function, 193, 475

LOG() function, 193, 475

LOG10() function, 475

overview, 192

PI() function, 193, 476

POWER() function, 193, 476

RADIANS() function, 193, 476

RAND() function, 193, 476

ROUND() function, 193, 476

SIGN() function, 193, 476

SIN() function, 193, 476

SQRT() function, 193, 476

SQUARE() function, 193, 476

TAN() function, 193, 476

MAX() function, 166–167, 208, 472

(max) option, 12–13

MAX (reserved word), 463

@@MAX_CONNECTIONS, 468

MAX_DYNAMIC_RESULT_SETS view, 516

MAXIMUM_CARDINALITY view, 516

@@MAX_PRECISION, 468

metadata functions

COL_LENGTH() function, 194, 476

COL_NAME() function, 194, 476

COLUMNPROPERTY() function, 194, 476

DATABASEPROPERTY() function, 194, 476

DATABASEPROPERTYEX() function, 194, 476

DB_ID() function, 195, 476

DB_NAME() function, 195, 476

FILE_ID() function, 195, 476

FILE_NAME() function, 195, 476

fn_listextendedproperty() function, 195

FULLTEXTCATALOGPROPERTY() function, 195, 477

FULLTEXTSERVICEPROPERTY() function, 195, 477

INDEX_COL() function, 195, 477

INDEXKEY_PROPERTY() function, 195, 477

INDEXPROPERTY() function, 195, 477

OBJECT_ID() function, 195, 477

OBJECT_NAME() function, 195, 477

OBJECTPROPERTY() function, 196, 477

overview, 193–194

method call, 409

Microsoft, 23, 24

Microsoft Access

overview, 20, 401

views created in, 351–353

Microsoft Search Service

DIFFERENCE() function, 304

overview, 302

SOUNDEX() function, 302–304

Microsoft Solutions Framework (MSF), 412

Microsoft SQL Server, 18–19

Microsoft Visual SourceSafe, 116

@@MICROSOFTVERSION, 468

middle-tier component, 406–408

MIN() function, 166–167, 208, 472

MIN (reserved word), 463

MINUTE (reserved word), 463, 465

miscellaneous functions, 456

MODIFIES (reserved word), 465

MODIFY (reserved word), 465

modifying data through views, 365–366

modifying records

filtering updates, 264–266

multiple tables, updating rows based on, 266–267

overview, 263

stored procedures, updating records using, 267–269

UPDATE statement, 264–269

views, updating using, 267

MODULE (reserved word), 463, 465

MODULE_CATALOG view, 515

MODULE_NAME view, 515

MODULE_SCHEMA view, 515

MONTH() function, 181, 474

MONTH (reserved word), 463, 465

MSF (Microsoft Solutions Framework), 398

multicolumn joins, 239–240

multiple associations, 39–40

multiple tables

deleting records based on, 271–272

joins, 245–246

queries, 233–251

updating rows based on, 266–267

multi-statement table-valued functions, 391–393

multi-system integrated solutions

application programming models, 411–412

overview, 411

project management challenges, 412

system integration and data exchange, 412

multi-table queries

joins, 233–246

subqueries, 233

union queries, 247–251

multi-valued columns, 40–41

MySQL, 20