Beginning Transact-SQL With SQL Server 2000 and 2005

Gates, Bill (Microsoft), 23

GENERAL (reserved word), 464

GET (reserved word), 462, 464

GETANSINULL() function, 201, 480

GETDATE() function, 180–181, 474

GETUTCDATE() function, 180–181, 474

GLOBAL (reserved word), 462, 464

GO (reserved word), 462, 464

GOTO (reserved word), 460, 462

GRANT command, 123, 346–347

GRANT (reserved word), 460, 462

GRANTEE view, 510, 517

GRANTOR view, 510, 517

graphical query designer, 88–93

grid pane in Query Designer tool, 53

GROUP BY clause, 213–217, 221, 452–453

GROUP (reserved word), 460, 462

grouped aggregates

COMPUTE BY clause, 228

COMPUTE clause, 225–228

GROUP BY clause, 213–217, 221

GROUPING() function, 223–225

HAVING clause, 218–219

subgrouping, 221

subtotals, 219–220

totals, 219–220

WITH CUBE operator, 222–223

WITH ROLLUP operator, 221–222

grouping data, 213–228

GROUPING() function, 223–225, 472

GROUPING (reserved word), 464

groups, adding, 436–442