L

@@LANGID, 467

@@LANGUAGE, 468

LANGUAGE (reserved word), 463, 465

LARGE (reserved word), 465

LAST (reserved word), 463, 465

LAST_ALTERED view, 516

LATERAL (reserved word), 465

layers, queries having, 108

LEADING (reserved word), 463, 465

LEFT() function, 185–186, 478

LEFT (reserved word), 461, 463

legacy outer joins, 239

LEN() function, 185, 478

LESS (reserved word), 465

LEVEL (reserved word), 463, 465

LIKE operator, 456–457

LIKE (reserved word), 461, 463

LIMIT (reserved word), 465

LINENO (reserved word), 461

linked server connection, 362

linking tables, 15

LOAD (reserved word), 461

LOCAL (reserved word), 463, 465

LOCALTIME (reserved word), 465

LOCALTIMESTAMP (reserved word), 465

location of users, 399

LOCATOR (reserved word), 465

locking function, 456

locking options, 393–395

locks

described, 16

exclusive locks, 18

intent locks, 18

shared locks, 17

update locks, 17

@@LOCK_TIMEOUT, 468

LOG() function, 193, 475

LOG10() function, 475

log shipping procedures

sp_add_log_shipping_alert_job, 492

sp_add_log_shipping_primary_database, 492

sp_add_log_shipping_primary_secondary, 492

sp_add_log_shipping_secondary_primary, 492

sp_change_log_shipping_primary_database, 492

sp_change_log_shipping_secondary_database, 492

sp_change_log_shipping_secondary_primary, 492

sp_cleanup_log_shipping_history, 492

sp_delete_log_shipping_alert_job, 492

sp_delete_log_shipping_primary_database, 492

sp_delete_log_shipping_primary_secondary, 492

sp_delete_log_shipping_secondary_database, 492

sp_delete_log_shipping_secondary_primary, 492

sp_help_log_shipping_alert_job, 492

sp_help_log_shipping_monitor_primary, 492

sp_help_log_shipping_monitor_secondary, 492

sp_help_log_shipping_primary_database, 492

sp_help_log_shipping_primary_secondary, 492

sp_help_log_shipping_secondary_database, 492

sp_help_log_shipping_secondary_primary, 492

sp_refresh_log_shipping_monitor, 492

sp_resolve_logins, 492

logged operations, 256

logical comparisons, 141

logical design, 28

logical gates, 141

logical operators, 319

long names naming standard, 112

looping, 384–386

LOWER() function, 188–190, 478

LOWER (reserved word), 463

lower-case, delimited naming standard, 112

LTRIM() function, 190–191, 479