SQL Server 2000 Stored Procedures Handbook (Experts Voice)

see user defined functions.

unchecked scheme, optimistic locking, 101

updatability of cursor, 68

data updatability for cursor, 69

OPTIMISTIC, 69

READ_ONLY, 68

SCROLL_LOCKS, 69

UPDATE action

firing triggers, 205

update locks, 94

user accounts

permissions issues, 223

user defined functions, 9

compared to cursors, 66

compared to stored procedures, 179, 194

converting non-deterministic function to deterministic, 183

creating, 181

CREATE FUNCTION statement, 181

example, 183

RETURNS statement, 181

description, 179

deterministic functions, 182

GLOBAL scope, 195

history in SQL Server, 180

non-deterministic functions, 182

scalar valued functions, 186

constraints, 187

schema binding, 193

WITH SCHEMABINDING statement, 193

TABLE data type, 188

multi-statement table function, 188, 190

single statement table function, 188

user ID's

compared to roles, 227

DBO, 225

permissions issues, 225

sysmembers table, 227

sysusers table, 227

user interface data validation, 125

compared to stored procedures, 125

security risks, 125

user stored procedures, 8