SQL Server 2000 Stored Procedures Handbook (Experts Voice)

care in using, 26

flow control of stored procedures, 26

warnings for cursor, 69

TYPE_WARNING, 69

WHILE loop

flow control of stored procedures, 25

syntax, 25

Windows registry, 152

care in modifying, 152

description, 153

hives, 153

introduction, 152

keys, 153

REGEDIT.EXE program, 153

REGEDT32.EXE program, 153

values, 153

Windows registry system stored procedures, 152

XP_Instance_Reg extended stored procedures, 160

XP_RegAddMultiString system stored procedure, 158

XP_RegDeleteKey system stored procedure, 157

XP_RegDeleteValue system stored procedure, 158

XP_RegEnumKeys system stored procedure, 156

XP_RegEnumValues system stored procedure, 157

XP_RegRead system stored procedure, 153

XP_RegWrite system stored procedure, 155

WITH ENCRYPTION clause

encrypted stored procedures, 239

WITH ENCRYPTION triggers

problems with replication, 215

triggers, 215

WITH MARK clause

BEGIN TRANSACTION command, 83

WITH RECOMPILE clause

CREATE PROCEDURE statement, 20

optimizing stored procedures, 37

reasons for using, 38

recompiling stored procedures, 20

specifying as part of execution, 38

syntax, 37

WITH SCHEMABINDING statement

user defined functions, 193

wrapper script

XP_SMTP_SendMail stored procedure, 173