Beginning Transact-SQL with SQL Server 2000 and 2005

Index

NUMERICS

1NF—first normal form, 32

2NF—second normal form, 32

3NF—third normal form, 32

A

ABS() function, 193, 475

ABSOLUTE (reserved word), 462, 464

ACID test, 254

ACOS() function, 193, 475

ACTION (reserved word), 462, 464

Active Directory procedures

sp_ActiveDirectory_Obj, 483

sp_ActiveDirectory_SCP, 483

Active Server Pages (ASP), 410

ADA (reserved word), 462

ADD (reserved word), 460, 462

adding records

defaults, inserting, 259–261

INSERT statement, 257–258

NULL values, inserting, 259–261

overview, 256

rows from another table, inserting, 261–262

SELECT INTO statement, 262

SELECT statement, 258

stored procedures, managing inserts using, 262–263

ad-hoc queries, 350

ADMIN (reserved word), 464

ADO (ActiveX Data Objects), 402

Adventure Works Cycles database

installation of, 45

overview, 44–45

AFTER (reserved word), 464

aggregate functions

AVG() function, 165–166, 208, 209–210

COUNT() function, 166, 208–209, 472

COUNT_BIG() function, 208, 472

grouping data, 213–228

GROUPING() function, 472

list of, 472

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

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

overview, 164–165, 207–208

statistical functions, 210–212

STDEV() function, 208, 212, 472

STDEVP() function, 208, 212, 472

subqueries, used in, 286

SUM() function, 167, 208, 209, 472

system-supplied aggregate functions used to summarize column values, list of, 208

user-defined aggregate function, 212

VAR() function, 208, 210–211, 472

VARP() function, 208, 211, 472

AGGREGATE (reserved word), 464

ALIAS (reserved ...