SQL Server 2000 Stored Procedures Handbook (Experts Voice)

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