WAITFOR() function
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