U

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

UDF (User-Defined Functions)
     advantages of
     Inline Functions
     return values
     Scalar Functions
     structure of
     Table Functions
UDTs (user-defined types) 2nd
     AddLoan
     CLR UDTs
         challenges of
         debugging
         IsNull property
         methods
         Null property
         NULL values
         Parse function
         performance tuning
         public properties 2nd
         public structure declaration
         referencing
         referencing and updating values
         SELECT queries
         SqlUserDefinedTypeAttribute
         stepping through code
         templates
         ToString function
         typICurrencyV2 UDT
         user-defined serialization
         validating data
         when to use
     creating with Server Explorer 2nd
     instantiating UDT variables
UID connection pools
underscore (_)
Unicode
     compared to ANSI
     data types
     literals
UNION queries
UNIQUE constraint
unique identifier data type
UNSAFE setting (CLR executables)
untyped DataSets
Update Criteria property
Update method 2nd
Update Query type (Query Designer)
UPDATE statement
     BLOBs
     concurrency
     decimal and floating point numbers
     generating with Query Designer
     parameter-based updates
     SET clause
     strings
     strongly typed data columns
     updating cursors
UpdateBatchSize property (SqlDataAdapter class)
UpdateCommand object
UpdateCommand property (SqlDataAdapter class)
UpdatedRowSource property (SqlCommand object) 2nd
UpdateEvent sample application
     CustomerUpdate stored procedure
     DataRow versions
    Update application
         batch mode updates
         RowUpdated event, trapping
         RowUpdating event, trapping
     Update method
updates
     batch mode updates
     CLR UDT (user-defined type) values 2nd
     with CommandBuilder
         action commands, generating
         adding to applications
         capabilities of
         concurrency management
         wizard dependency on
    complex updates with server-side logic
         executing with RowUpdating event
         overview of
        UpdateEvent example [See application design, UpdateEvents application.]
    concurrency management
         Identity column values
         overview of
     rows
         BLOBs
         concurrency
         decimal and floating point numbers
         parameter-based updates
         strings
         strongly typed data columns
         UPDATE SET syntax
     server-side cursors
     SqlDataAdapter class
    with TableAdapter
         example
         generated parameters, managing
         parameters, configuring with Visual Studio
         stored procedures
     triggers
UPPER function
user choices, limiting
user databases
     creating
     managing
User ID keyword
user instances, enabling 2nd
user settings
user-defined types [See UDTs (user-defined types).]
usernames
Using operator 2nd