Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

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