Exam Ref 70-761 Querying Data with Transact-SQL, First Edition

Index

Symbols

@@IDENTITY function 82

@maxallowedqty parameter 260

@parameter IS NULL 253

@params parameter 255

@qty variable 262

@@ROWCOUNT function 80

@sql variable 255

@stmt parameter 255

@sumqty variable 262

@@TRANCOUNT function 265, 272, 277–278, 279, 302, 304

A

add (+) operator 83

aggregate functions 84–86, 153–155

window 168–172

aggregation element 160

aliases

column 19

table 18

aliasing 18–20, 48

columns 145

external 145

inline 223

internal 145

all-at-once concept 106–107

ALL predicate 131

ALL subclause 191

ALTER PROC command 250

ALTER TABLE statement 122–124

ALTER VIEW command 229

American National Standards Institute (ANSI) 3

AND operator 24

Anti Semi Join optimization 137

ANY predicate 131–132

application-time period tables 177

APPLY ...