O'Reilly logo

Exam Ref 70-761 Querying Data with Transact-SQL, First Edition by Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required