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 |