T



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]

T-SQL
     ad hoc queries, integrating into applications 2nd
     aliasing
     ALTER PROCEDURE statement
     BETWEEN expressions
     case-sensitive queries
     CLR functions, addressing
     concatenated T-SQL expressions
     CREATE PROCEDURE statement
     CREATE RULE statement
     creating queries
     dates in queries
     DECLARE statement
     DELETE statement
     executing with Run Selection feature
     FETCH operator
     IN expressions
     INSERT statement
         Identity values
         NULL and DEFAULT values
     IS NOT NULL statement
     IS NULL statement
     JOIN operator
     LIKE expressions
     literals in queries
     NULL values
     preparing statements for execution
    SELECT queries
         CLR UDTs (user-defined types)
         creating
         creating cursors with
         executing
         joins
         limiting number of rows returned
         ORDER BY clause
         ordering rows returned
         parameters
         SELECT INTO
         WHERE clause
     sql_variant datatype
     T-SQL debugging
         from code
         against local instances
         on remote instances
         with breakpoints
    T-SQL Functions
         advantages of
         Inline Functions
         return values
         Scalar Functions
         structure of
         Table Functions
     T-SQL Rules
         binding to columns
         creating
     T-SQL views
     UNION queries
     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
table data type
Table Functions
table-valued functions (TVFs)
TableAdapter Configuration wizard (TACW)
TableAdapter objects 2nd
     adding parameters to queries
    binding to
         with drag and drop
         without drag and drop
     configuring
     defined
     generated parameters, managing
     intertable relationships, managing in Data Source designer
     limitations of
     overview of
     parameters, configuring with Visual Studio
     selecting Query methods
     single-table TableAdapters
     stored procedures 2nd
     TACW (TableAdapter Configuration wizard)
     updating tables with
TableDefinition setting (SqlMethodAttribute property)
TableMappings property (SqlDataAdapter class)
tables
     aliases
     check constraints
    columns
         binding rules to
         constraints
         definition of
         strongly typed data columns
     custom report cache tables, building
     definition of
     derived tables
     designing
     editing with Server Explorer
     identifiers
     indexes
     INSERTED and DELETED pseudo tables
     joins
         Cartesian products
         inner joins
         outer joins
     maximum size of
     naming
     NULL values
     parent/child relationships
    primary keys
         changing
         defining
         GUIDs (globally unique identifiers)
         multi-column primary keys
         primary key/foreign key relationships
    rows
         definition of
         dropping all rows
         inserting
         limiting number of rows returned
         ordering rows returned
         row-overflow storage
         updating
     temporary tables 2nd
     unique identifiers
    updating [See updates.]
Tabular Data Stream (TDS) 2nd
TACW (TableAdapter Configuration wizard)
TCP/IP (Transmission Control Protocol/Internet Protocol)
TDS (Tabular Data Stream) 2nd
team development
Team Edition (Visual Studio)
#Temp tables 2nd
tempdb database
templates
     CLR UDTs (user-defined types)
     Visual Studio templates
temporary tables 2nd
Terminate function
test scripts (CLR executables)
     creating
     executing
testing
     aggregates
     CLR executables
         creating test scripts
         executing test scripts
     CLR stored procedures
     for NULL values
     reports 2nd
     SqlDataReader streams for data 2nd
     typICurrencyV2 UDT
     Web Services
Text Boxes, prompting for parameter values
text data type
text files, accessing
TextBox property
threads [See also asynchronous execution of SqlCommand objects, BeginExecuteNonQuery function.]
Timeout parameter (server reports)
timeouts
Timestamp columns
timestamp data type
tinyint data type
Tool Tray
Toolbox (Visual Studio) [See also controls, BindingNavigator.]
     BindingNavigator class
     BindingSource class
         events
         methods
         properties
         typical data binding scenarios
     DataGridView control
     DataSet element
     deprecated data access controls
     finding controls in
     ProgressBar control
     Tool Tray
Tools menu commands
     Import and Export Settings
     Options
ToolStripPanel controls
ToString function 2nd
ToTable method
Trace Properties dialog (SQL Profiler)
traces (SQL Profiler)
     evaluating
     starting
transaction logs
Transaction property (SqlCommand object) 2nd
transactions
     CLR executables
     transaction logs
transactions-per-second limits (DBMSs)
Transmission Control Protocol/Internet Protocol (TCP/IP)
trapping
     RowUpdated event
     RowUpdating event
triggers 2nd
     CLR triggers
     creating
     DDL triggers
     DML triggers
     INSERTED and DELETED pseudo tables
     updates
TRUNCATE TABLE operator
Trusted_Connection keyword
tuning performance [See performance, CLR executable performance, evaluating.]
TVFs (table-valued functions)
type safety
typed DataSets
TypeId setting (SqlMethodAttribute property)
types [See data types, ANSI.]
typICurrencyV2 UDT
     IBinarySerialize Read and Write subroutines
     Parse function
     private variables
     testing
     ToString function




Hitchhiker's Guide to Visual Studio and SQL Server(c) Best Practice Architectures and Examples
Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)
ISBN: 0321243625
EAN: 2147483647
Year: 2006
Pages: 227

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net