P

@@PACKET_ERRORS, 204, 471

@@PACK_RECEIVED, 204, 470

@@PACK_SENT, 204, 470

PAD (reserved word), 462, 466

parameter lookup list, 424–425

PARAMETER (reserved word), 466

parameterized queries, 420–423

parameterized views, stored procedures as, 366–367

parameters, 341–342

PARAMETERS (reserved word), 466

PARAMETERS view, 513

PARAMETER_STYLE view, 516

parent-child relationships, 14

parentheses, use of, 148–150

PARSENAME() function, 201, 481

PARTIAL (reserved word), 462, 466

partitioned views, 357–360

partitioning data, 249–251

Pascal Case naming standard, 112

PASCAL (reserved word), 462

PATH (reserved word), 466

PATINDEX() function, 185, 475, 479

PERCENT (reserved word), 460

PERCENT statement, 155–156

performance and, 250–251

PERMISSIONS() function, 201, 481

physical design, 28–29

PI() function, 193, 476

PLAN (reserved word), 460

PL/SQL (Procedure Language/Structured Query Language), 19

POSITION (reserved word), 462

POSTFIX (reserved word), 466

POWER() function, 193, 476

PRECISION (reserved word), 460, 462

predicate, filtering records in join clause using, 243–244

PREFIX (reserved word), 466

PREORDER (reserved word), 466

PREPARE (reserved word), 462, 466

presentation layer and n-tier component solutions, 408

PRESERVE (reserved word), 462, 464

primary key constraints

naming, 324

overview, 331–333

primary keys, 6–7, 29–30

PRIMARY (reserved word), 460, 462

PRINT (reserved word), 460

PRIOR (reserved word), 462, 464

PRIVILEGES (reserved word), 462, 464

PRIVILEGE_TYPE view, 510, 517

PROC (reserved word), 460

procedure cache, 44

Procedure Language/Structured Query Language (PL/SQL), 19

PROCEDURE (reserved word), 460, 462

Professional SQL Server 2000 Programming (Viera), 1, 304

Professional SQL Server 2005 Programming (Viera), 1, 304

Professional SQL Server Reporting Services (Wiley Publishing, Inc.), 414

Profiler, 49, 73

profiler procedures

sp_trace_create, 495

sp_trace_generateevent, 495

sp_trace_setevent, 495

sp_trace_setfilter, 495

sp_trace_setstatus, 495

programming objects

business logic, processing, 378–380

CASE statement, 382–384

complexity, hiding, 364–365

conditional logic, 380–382

creating views, 351–356

Delete procedure, 374

errors, handling and raising, 374–378

federated views, 360–363

IF statement, 380–382

inline table-valued functions, 390–391

Insert procedure, 371–373

locking options, 393–395

looping, 384–386

Microsoft Access, creating views in, 351–353

modifying data through views, 365–366

multi-statement table-valued functions, 391–393

parameterized views, stored procedures as, 366–367

partitioned views, 357–360

record maintenance, 370

rows, ordering, 356–357

scalar functions, 386–390

securing data, 363

SQL Script, creating views in, 354–356

SQL Server 2000, error handling in, 374–377

SQL Server 2005, error handling in, 378

stored procedures, 366–386

transaction management, 393–395

Update procedure, 373–374

using parameters, 367–369

values, returning, 369–370

views, 350–366

virtual tables, 350

Visual Studio, creating views in, 353–354

project management challenges, 412

projects in SQL Server Management Studio, 82–83

PUBLIC (reserved word), 460, 462

PWDCONPARE() function, 481

PWDENCRYPT() function, 482