U

UDFs. See User -defined functions (UDFs)

UDT. See User-defined type (UDT)

UI. See User Interface (UI)

UML. See Unified Modeling Language (UML)

Unicode datatype, 103105

Unified Modeling Language (UML), 76, 92

UNIQUE constraints, 108110

Uniqueidentifier, 107, 209

Unique identifier column, 264265

UNIX, 123

UPDATE, 133, 136, 184

UPDATE(column) function, 278

Update operations, 279281

UPDATE statement

assign new values to columns , 274275

change content of large (BLOB) column, 276

change content of large (MAX) column, 276

create, with SQL Server Management Studio, 273274

defined WHERE condition, 274

use arithmetic to update information, 275276

UPDATETEXT sentence , 276

Upgrade Advisor, 17

UPPER function, 159

User database, 47

User-defined functions (UDFs) common language runtime user-defined functions (CLR UDF), 207217

defined by using T-SQL language, 192

design, 163164

designing views, 163164

in-line user, 197199

scalar functions, 163164, 194196

tabled-valued, 200202

T-SQL datatype, 107

use stored procedures and, 207

User-defined type (UDT), 107

USER_ID function, 159

User interaction requirements. See Requirements

User interface (UI), 25, 287289

User_name(), 274

USER_NAME function, 159

User profile, compile, 84

User surveys, write, 7475