S

SAFETY option for failover, 380

sample database, 6–9

SAVE TRANSACTION statement, 301–302

savefig function, 764, 767–768

savepoints for transactions, 301

scalar functions, 75

date, 77

metadata, 81–82

numeric, 75–77

string, 78–79

system, 80–81

user-defined, 207, 210, 667–670

scalar operators, 82–83

scales package, 744–745

scatter function, 767

schedules

backups, 365

jobs, 394

reports, 620

SCHEMA_AND_DATA option

databases, 504

tables, 511

SCHEMA_ONLY option

databases, 504

tables, 511

SCHEMABINDING clause

procedures, 510

schemas, 638

views, 246, 636

schemas

data warehouses, 526–528

default, 275–276

description, 4

JSON documents, 677–678

roles, 281

security, 272–276

stored procedures, 202

system base tables, 216, 220–221

tables, 91, 102

user-defined ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial