O'Reilly logo

Sams Teach Yourself T-SQL in One Hour a Day by Alison Balter

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

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

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