Главная    Ex Libris    Книги    Журналы    Статьи    Серии    Каталог    Wanted    Загрузка    ХудЛит    Справка    Поиск по индексам    Поиск    Форум   
blank
Авторизация

       
blank
Поиск по указателям

blank
blank
blank
Красота
blank
Beauchemin B., Sullivan D. — A Developer's Guide to SQL Server 2005
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


Язык: en

Рубрика: Руководства по программному обеспечению/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2006

Количество страниц: 1088

Добавлена в каталог: 23.10.2006

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
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
1 2 3 4 5 6 7 8 9 10
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2026
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте