naming stored procedures, 17
avoiding sp_ prefix, 17
renaming using sp_rename, 19
nested stored procedures, 27, 131
@@NESTLEVEL function, 27, 131
problems with, 28, 131
recursion, 27
nested trigger option
immediate update subscriber, 214
queued update subscriber, 214
nesting transactions
@@TRANCOUNT variable, 84
simple transactions, 84
networking
stored procedures, 11
NOLOCK hint, 95
non-deterministic functions, 182
converting non-deterministic function to deterministic, 183
DATEADD() function, 185
DATEPART() function, 185
description, 182
GETDATE() function, 184
user defined functions, 182
Northwind example database
restoring to default condition, 31
NOT FOR REPLICATION option
creating triggers, 203
NVARCHAR parameter
XP_Test_Mapi_Profile system stored procedure, 172