Q–Q
1140
printing
messages in the message window, 581
priority
process, 25
proc_role Adaptive Server Enterprise function, 310
ProcedurePages property, 1095
procedures, 579
altering, 389
catalog, list, 963
CREATE PROCEDURE SQL statement, 460
creating, 453
creating in Transact-SQL, 460
dropping, 505
executing in dynamic SQL, 518
executing stored in Transact-SQL, 516
exiting, 593
extended, list, 981
external function calls, 446, 456
invoking, 410
raising errors in Transact-SQL, 584
replicating, 389
resuming execution of, 592
returning values from, 593
system, 961
Transact-SQL, list, 988
variable result sets, 454, 502
ProcessCPU property, 1095
ProcessCPUSystem property, 1095
ProcessCPUUser property, 1095
processors
multiple, 30
number used, 30
product name
retrieving, 984
ProductName property, 1095
ProductVersion property, 1095
projections
SELECT statement, 601
properties
about, 1090
connection, 963, 1090
database, 963, 1101
server, 357, 1095
PROPERTY function
SQL syntax, 357
property functions
about, 1090
PROPERTY_DESCRIPTION function
SQL syntax, 356
PROPERTY_NAME function
SQL syntax, 358
PROPERTY_NUMBER function
SQL syntax, 358
protocol stacks
TCP/IP, 67
protocols
disabling shared memory, 35
PROWS connection parameter, 62
proxy procedures
creating, 453
proxy tables
creating, 441, 467
PUBLIC group
in the system tables, 1048
publications
updating, 637
PURGE clause
FETCH statement, 526
PUT statement
SQL syntax, 582
putting
rows into cursors, 582
PWD connection parameter, 61
Q
Qualify_owners
replication option, 206
QUARTER function
SQL syntax, 358
QUERY_PLAN_ON_OPEN option, 164, 206
Query_plan_on_open property, 1091