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