UDFs
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