Sams Teach Yourself T-SQL in One Hour a Day

Index

Symbols

@@ functions, 231

@@Error, 219-220

@@Identity, 218

@@RowCount, 217

@@TranCount function, 218

explained, 216

% (percent) sign, 104

_ (underscore), 95, 104

A

accounts, dbo, 295

action queries

DELETE statement, 146

INSERT statement, 143-144

SELECT INTO statement, 145

TRUNCATE statement, 147

UPDATE statement, 141-142

Activity Monitor, 25

Actual Execution Plan button, 361

Add Features to an Existing Installation option, 379

Add Objects dialog box, 306-307

Add Table dialog box, 70-71, 76, 180, 192-193

administration

column permissions, 315-316

function permissions, 315

object permissions, 302-309

assigning permissions to particular objects, 302-305

assigning permissions to users or roles, 305-309

stored procedure permissions, 314

table ...