Авторизация
Поиск по указателям
Beauchemin B., Sullivan D. — A Developer's Guide to SQL Server 2005
Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: A Developer's Guide to SQL Server 2005
Авторы: Beauchemin B., Sullivan D.
Аннотация: Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide—accurate, comprehensive, and packed with examples. ADeveloper's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases.
You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL: 1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.
Key coverage includes
• Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
• Writing procedures, functions, triggers, and types in .NET languages
• Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
• Effectively using the XML data type and XML queries
• Implementing native SQL Server 2005 Web Services
• Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
• Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
• Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications
Язык:
Рубрика: Руководства по программному обеспечению /
Статус предметного указателя: Готов указатель с номерами страниц
ed2k: ed2k stats
Год издания: 2006
Количество страниц: 1088
Добавлена в каталог: 23.10.2006
Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
Static type checking 2nd
Statistics for SqlClient
StatisticsEnabled property
STATUS option for WITH ACTIVATION
Status values for stored procedures
STDEV function
STOPPED state for endpoints 2nd
Stored procedures
Stored procedures for Notification Services 2nd
Stored procedures for Web Services
Stored procedures in ADO.NET
Stored procedures in clients
Stored procedures in CLR
Stored procedures in T-SQL
Stored procedures in Visual Studio
Stored procedures, attributes for
Stored procedures, extended 2nd 3rd
Stored procedures, Object Explorer for
Stored procedures, parameters for
Stream property
Streams in SQLXML
Strict validation
StringCollection class
strings
Strings for dates
Strings in CLR
Strings in LDim
Strings in Visual Studio
Strings in XML 2nd
Strings in XQuery
Strings, concatenation
Strong typing 2nd
Strongly typed instances
struct keyword
Structured data types
Structured exception handling
Structured exception handling for in-process data access
Structured exception handling in hosting
Structured exception handling in T-SQL
Subscriber class 2nd
SubscriberDevice class 2nd
SubscriberId property
Subscribers 2nd 3rd
Subscription classes 2nd
SubscriptionClasses class 2nd
Subscriptions 2nd 3rd 4th
SUBSTRING data type
SUM function 2nd
SumLDim function 2nd 3rd
Summary window
SuppressFinalize method
Surface Area Configuration tool 2nd
SUSER_NAME function
Sybase database system
Symmetric keys 2nd
Synchronization
Synchronization thread
Synchronization, transaction
Synonyms
sys.assemblies table
sys.assembly_files table 2nd
sys.assembly_references table
sys.conversation_endpoints view 2nd 3rd
sys.conversation_groups view
sys.databases view
sys.dm_clr views
sys.dm_clr_appdomains view
sys.dm_os views
sys.dm_os_memory_clerks view
sys.dm_qn_subscriptions view
sys.dm_tran_ views
sys.endpoints view
sys.http_endpoints view 2nd
sys.routes view
sys.soap_endpoints view
sys.transmission_queue system view
sysadmin role
syslogins view
SYSTEM clause
System metadata tables
System process identifiers (SPIDs)
System.Data.dll file
System.Data.OracleClient.dll file
SystemDataAccess property 2nd
SystemDataAccessKind attribute
T-SQL (Transact-SQL) 2nd
T-SQL (Transact-SQL) for asynchronous messages
T-SQL (Transact-SQL) for pulley function
T-SQL (Transact-SQL), best practices
T-SQL (Transact-SQL), enhancements
T-SQL (Transact-SQL), enhancements, APPLY operators
T-SQL (Transact-SQL), enhancements, CTEs
T-SQL (Transact-SQL), enhancements, error handling
T-SQL (Transact-SQL), enhancements, improvements
T-SQL (Transact-SQL), enhancements, INTERSECT and EXCEPT operators
T-SQL (Transact-SQL), enhancements, ON DELETE and ON UPDATE clauses
T-SQL (Transact-SQL), enhancements, OUTPUT clause
T-SQL (Transact-SQL), enhancements, partitioning
T-SQL (Transact-SQL), enhancements, PIVOT operator
T-SQL (Transact-SQL), enhancements, ranking functions
T-SQL (Transact-SQL), enhancements, recursive queries
T-SQL (Transact-SQL), enhancements, TABLESAMPLE clause
T-SQL (Transact-SQL), enhancements, TOP clause
T-SQL (Transact-SQL), enhancements, UNPIVOT operator
T-SQL (Transact-SQL), integration of
T-SQL (Transact-SQL), null values in
T-SQL (Transact-SQL), scripts
Table-access links
Table-valued CLR functions
TableCollection class
TableDefinition property 2nd 3rd 4th
TABLESAMPLE clause
Tabular Data Stream (TDS) protocol 2nd 3rd
TARGET direction for contracts
Target property 2nd
targetNamespace attribute 2nd 3rd
Task management for runtime hosting
TDS (Tabular Data Stream) protocol 2nd 3rd
TEMPDB file
Template Explorer
Templates in SSMS
Terminate method 2nd 3rd
Test Scripts folder 2nd
TEXT data type
TEXT data type for LOBs
TEXT data type in clients 2nd
TEXT data type in XML 2nd
TEXT data type vs. MAX
text function
TextA event
TextW event
threads
Threads in AppDomains 2nd
Threads, scheduling
Tiles
TIMEOUT clause
Timeouts for conversations
Timers for conversations
Timestamps in message processing
TNS (transparent network substrate)
TO SERVICE clause
TO SERVICE clause for broker instances
TO SERVICE clause for contracts
TO SERVICE clause for conversations
TO SERVICE clause for messaging applications 2nd
ToBytes method 2nd
TOP clause
ToString method
ToString method for DataSet serialization
ToString method for UDTs
ToString method for UDTs from DataReaders
ToString method for UDTs in ODBC, OLE DB, and ADO
ToString method in LDim 2nd 3rd
ToString method in Object
ToString method, overriding
TPC-C (Transaction Processing Performance Council benchmark C) benchmark
Tracepoints
tracerpt command
Tracing data access 2nd
Tracing data access, application choices for
Tracing data access, basis of
Tracing data access, CSV files for
Tracing data access, ETW in
Tracing data access, for parameter binding problems
Tracing data access, reading output in
Tracing data access, running
Tracing data access, setting up
Tracing data access, user data in
Transact-SQL [See T-SQL (Transact-SQL).]
Transaction library
Transaction Processing Performance Council benchmark C (TPC-C) benchmark
Transaction-level SNAPSHOT isolation
transaction.h file
TransactionRequired attribute
Transactions
Transactions library 2nd
Transactions, autonomous
Transactions, best practices
Transactions, business [See Business transactions.]
Transactions, declarative and promotable
Transactions, distributed 2nd 3rd
Transactions, for in-process data access
Transactions, isolation levels in
TransactionScope class
TransactionScope class for distributed transactions 2nd
TransactionScope class for promotable transactions
TransactionScope class, SqlConnections in
TransactionScopeOption 2nd
Transparent network substrate (TNS)
TreeMember method
TriggerContext property
Triggers
Triggers for in-process data access
Triggers in CLR
Triggers, DDL
TrustServerCertificate parameter
TRY/CATCH blocks 2nd 3rd
TryParse method
Tuples
Type property
Type property for SMO objects
Type property in SqlNotificationEventArgs
TYPE qualifier FOR XML
Typed XML
Types
Types for clients
Types in XQuery
Types in XSD
Types, defined
Types, SqlTypes
Types, SQLXML
Types, user-defined [See User-defined types (UDTs).]
Types, Visual Studio
Types, XML [See XML and XML data type.]
UDDI (Universal Description, Discover and Integration) servers
UDTs [See User-defined types (UDTs).]
UNCHECKED DATA option
Undo method
Unicode strings
Uniform Resource Names (URNs)
Uniform Resource Names (URNs) for SMO object identity
Uniform Resource Names (URNs), retrieval restrictions
UNION ALL operator 2nd
UNION queries
UNIQUE constraints
UNIQUEIDENTIFIER class
UNIQUEIDENTIFIER class for broker instances
UNIQUEIDENTIFIER class for conversation groups
UNIQUEIDENTIFIER class for messaging applications
Units of work
Universal Description, Discover and Integration (UDDI) servers
UNPIVOT operator
UnquoteIdentifier property
UNSAFE ASSEMBLY permission 2nd
UNSAFE security level 2nd
UNSAFE security level finalizers in
UNSAFE security level for assemblies 2nd
Untyped XML
Update command 2nd 3rd
UPDATE permission 2nd
UPDATE statement
UPDATE statement, CTEs with
UPDATE statement, OUTPUT clause in
UPDATE statement, TOP clause in
UpdateBatchSize method
UpdateCommand command
UPDATETEXT method
Updating XML columns
URLs
URLs for Web Services
URLs, ACL for
URLs, endpoint
URLs, reservations for
URNs (Uniform Resource Names)
URNs (Uniform Resource Names) for SMO object identity
URNs (Uniform Resource Names), retrieval restrictions
USE PLAN query hint
UseEventHandler method
UseExecXmlReader method
User assemblies, maintaining
User ID keyword
USER keyword in AddUser
User libraries
User-defined aggregates
User-defined aggregates best practices
User-defined aggregates, creating
User-defined aggregates, implementing
User-Defined Function template
User-defined functions
User-defined types (UDTs) 2nd
User-defined types (UDTs) in Visual Studio
User-defined types (UDTs) in XML 2nd
User-defined types (UDTs), aggregate
User-defined types (UDTs), best practices
User-defined types (UDTs), binary implementation in
User-defined types (UDTs), comparing
User-defined types (UDTs), creating 2nd
User-defined types (UDTs), for clients
User-defined types (UDTs), for clients .NET Framework
User-defined types (UDTs), for clients from DataReaders
User-defined types (UDTs), for clients in ODBC, OLE DB, and ADO
User-defined types (UDTs), Format.Native vs. Format.UserDefined implementations
User-defined types (UDTs), helper functions in
User-defined types (UDTs), IBinarySerialize
User-defined types (UDTs), maintaining
User-defined types (UDTs), null value implementation in
User-defined types (UDTs), objects for
User-defined types (UDTs), overview
User-defined types (UDTs), permissions for
User-defined types (UDTs), public members in
User-defined types (UDTs), purpose of
User-defined types (UDTs), source code for
User-defined types (UDTs), string implementation in
User-defined types (UDTs), validation in
UserDefinedFunctions class
UserDefinedMessage class
users
Users in authentication
Users, adding to databases
Users, schema separation from
Реклама