Index

# and ## prefix for local/global, 91–93, 312

% wildcard, 12, 131–133

+ operator, 35

@@CURSOR_ROWS automatic variable, 263, 268–269

@@DBTS automatic variable, 74–75

@@ERROR automatic variable, 103–104, 118, 288–289, 327–328

@@FETCH_STATUS automatic variable, 263, 269

@@IDENTITY automatic variable, 75

@@MAX_PRECISION automatic variable, 329

@@MICROSOFTVERSION automatic variable, 502

@@NESTLEVEL automatic variable, 324, 328, 331

@@OPTIONS automatic variable, 324

@@PROCID automatic variable, 324

@@ROWCOUNT automatic variable, 33, 118, 334

@@SPID automatic variable, 324

@@TRANCOUNT automatic variable, 21, 293, 295–296, 298–300, 324

@@VERSION automatic variable, 9

_ wildcard, 12, 131–133

3GL versus SQL approach, medians, 180–181

A

ACID (atomic, ...

Get The Guru's Guide to Transact-SQL 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.