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, 277278, 279, 302, 304

A

add (+) operator 83

aggregate functions 8486, 153155

window 168172

aggregation element 160

aliases

column 19

table 18

aliasing 1820, 48

columns 145

external 145

inline 223

internal 145

all-at-once concept 106107

ALL predicate 131

ALL subclause 191

ALTER PROC command 250

ALTER TABLE statement 122124

ALTER VIEW command 229

American National Standards Institute (ANSI) 3

AND operator 24

Anti Semi Join optimization 137

ANY predicate 131132

application-time period tables 177

APPLY ...

Get Exam Ref 70-761 Querying Data with Transact-SQL, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.