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]

IAsyncResult interface

IBindableComponent interface

IDENT_CURRENT() function

identifiers

     GUIDs (globally unique identifiers)

Identity columns

     concurrency management

         @@Identity global variable 2nd

         ADO.NET

         parent/child relationship updates

         retrieving new Identity values

         SQL Server

     definition of

Identity values (INSERT statement)

image data type

image library (Visual Studio), installing

Import and Export Settings command (Tools menu)

Import and Export Settings Wizard

importing data 2nd

Imports statement

imprecise numbers

IN expressions

indexes

     creating

     indexed views

InfoMessage event (connections)

InfoMessage messages, populating

Init function

Initial Catalog keyword

injection attacks

Inline Functions

inner joins

Insert Results Query type (Query Designer)

INSERT statement

     generating with Query Designer

     Identity values

     NULL and DEFAULT values

Insert Values Query type (Query Designer)

InsertCommand object

InsertCommand property (SqlDataAdapter class)

INSERTED pseudo table

installing

     DACW (DataAdapter Configuration Wizard)

     deprecated data components

     example applications

     example databases

     SQL Server

         Advanced Services options

         authentication mode

         collating sequences

         instance names

         quiet installs

         Service Account

         Setup program

         User Instances, enabling

    SQL Server Express Edition

         common instances

         default instances

         independent instances

    Visual Studio

         image library

         MSDN documentation

         Setup program

instances

     establishing aliases to

     finding for establishing connections

     multiple instances

    object instantiation

         constructors

         overview of

         scope

         Using block

     overview of

     SqlCommand instances

     UDT variables

int data type

Integrated Security keyword

interfaces

     IAsyncResult

     IBindableComponent

Internet access

     connection strategy

     server/firewall configuration

intertable relationships, managing in Data Source designer

intranet access connection strategy

InvokeIfReceiverIsNull setting (SqlMethodAttribute property)

IS NOT NULL statement

IS NULL statement

IsCompleted property (IAsyncResult interface)

IsDBNull function

IsDeterministic setting (SqlMethodAttribute property)

IsDrillthroughReport property 2nd

IsMutator setting (SqlMethodAttribute property)

IsNull property (CLR UDTs)

IsPrecise setting (SqlMethodAttribute property)