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
aggregation element 160
aliases
column 19
table 18
columns 145
external 145
inline 223
internal 145
ALL predicate 131
ALL subclause 191
ALTER PROC command 250
ALTER VIEW command 229
American National Standards Institute (ANSI) 3
AND operator 24
Anti Semi Join optimization 137
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.