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] RDL (report definition language) converting to RDCL RDLC extension files converting RDL to DataSets block Read method real data type records affected value, capturing Reflector Refresh method 2nd RefreshReport method registering servers with Server Explorer reinstalling DACW (DataAdapter Configuration Wizard) deprecated data components relational databases [See also ADO.NET, class names; DBMSs (database management systems), client considerations.] administrative functions Auto Close option importing/exporting data .MDF database files, attaching backing up BLOBs, avoiding check constraints columns binding rules to definition of strongly typed data columns concurrency constraints creating in code creating with Server Explorer data types ANSI 2nd barbinary bigint binary bit char 2nd cursor datetime decimal doubleprecision exact numerics float image imprecise numbers int money nchar ntext numeric nvarchar real smalldata smallint smallmoney sql_variant sysname table text timestamp tinyint UDTs (user-defined types) Unicode 2nd uniqueidentifier varchar 2nd xml database connections [See connections, client/server connection management.] Database Diagrams creating definition of definition of design principles example databases aliases attaching chapter-specific configuration issues installing identifiers indexes maximum size of multiple databases normalization definition of first normal form second normal form third normal form object names overview of 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 2nd limiting number of rows returned ordering rows returned row-overflow storage updating rules system databases tables [See tables, aliases.] transaction logs transactions 2nd updating [See updates.] user databases creating managing relationships, managing in Data Source designer releasing connection pool connections remote debugging RemoveFilter method RemoveSort method Render method 2nd rendering server reports RenderingBegin event RenderingComplete event RenderStream method replication in SQL Server Express Edition in SQLEv (SQL Server Everywhere Edition) SqlCommand objects report definition language [See RDL (report definition language).] Report Designer (BIDS) 2nd Report Items toolbox report parameters creating definition of sample application Report Viewer configuring events methods overview of properties ReportEmbeddedResource property (LocalReport class) ReportError event ReportExport event Reporting Services architecture BIDS Report Designer 2nd features overview of RDL (report definition language) sample summary report ReportPath parameter (server reports) reports adding to projects BIDS Report Designer 2nd click-through reports Data Sources expressions formatting laying out LocalReport class events methods properties Matrix report building custom report cache table data considerations grouping data initial SELECT Query layout testing overview of Query parameters RDL (report definition language) converting to RDCL RDLC extension files converting RDL to DataSets block Report Items toolbox report parameters creating definition of sample application report queries Report Viewer configuring events methods overview of properties Reporting Services architecture features overview of sample summary report server reports accessing on Reporting Services methods and functions parameters 2nd rendering ServerReport class SubReport item testing ReportServer database ReportServerCredentials parameter (server reports) ReportServerUrl parameter (server reports) reserved words, avoiding in object names Reset method ResetBindings method ResetCommandTimeout method 2nd ResetCurrentItem method ResetDbType method ResetItem method ResetSqlType method resetting server report parameters resources, managing restoring data backup and deployment issues importance of security resultsets CLR stored procedures fetching MARS (Multiple Active Resultsets) ResumeBinding method retrieving data Identity values RETURN values populating stored procedures ReturnProviderSpecificTypes property (SqlDataAdapter class) reusable components, building Roeder, Lutz roles (SQL Server) RowFilter property (DataView class) rows definition of dropping all rows inserting Identity values NULL and DEFAULT values SELECT INTO syntax limiting number of rows returned ordering rows returned row-overflow storage SqlDataReader rows, fetching updating BLOBs concurrency decimal and floating point numbers parameter-based updates strings strongly typed data columns UPDATE SET syntax RowState property (DataRow objects) RowStateFilter property (DataView class) RowUpdated event RowUpdating event executing Update logic with trapping rules business rules extended properties overview of T-SQL Rules binding to columns creating Run Selection feature running report queries |
Категории