Авторизация
Поиск по указателям
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
Предметный указатель
FillRowMethod method 2nd 3rd
FillRowMethodName property 2nd 3rd 4th 5th
FilterCallbackFunction function
Final queries
Finalization, object
Finalize method 2nd
Finalizers in exceptional handling
Finalizers in exceptional handling, finally blocks
Finalizers in exceptional handling, finally blocks in exceptional handling
Finalizers in exceptional handling, finally blocks in T-SQL
Finalizers in exceptional handling, Firehose mode
Finalizers in exceptional handling, Firewalls
Finalizers in exceptional handling, Fix points in recursive queries
Finalizers in exceptional handling, Float data types
Finalizers in exceptional handling, FLWOR expressions 2nd 3rd 4th
Finalizers in exceptional handling, fn:collection function
Finalizers in exceptional handling, fn:doc function
Finalizers in exceptional handling, FOR clause
Finalizers in exceptional handling, FOR clause in FLWOR expressions
Finalizers in exceptional handling, FOR clause in PIVOT
Finalizers in exceptional handling, FOR clause in UNPIVOT
Finalizers in exceptional handling, FOR clause in XQuery
FOR PATH clause
FOR PROPERTY clause
FOR SOAP clause
FOR SOAP clause for batches 2nd
FOR SOAP clause for endpoints 2nd
FOR SOAP clause for rowsets
FOR SOAP clause WSDL option in 2nd 3rd 4th
FOR VALUE clause
FOR XML AUTO clause 2nd
FOR XML clause
FOR XML clause for inline XSD format schema
FOR XML clause for nested XML queries
FOR XML clause for NULL values
FOR XML clause for root elements
FOR XML clause for whitespace entitization
FOR XML clause for XML data types
FOR XML clause support for 2nd 3rd
FOR XML clause with UDTs
FOR XML clause, XMLSCHEMA version
FOR XML EXPLICIT clause 2nd
FOR XML PATH clause
FOR XML RAW clause
force flag in Update
FOREIGN KEY clause 2nd
FORMAT option for WEBMETHOD clause
Format property in SqlUserDefinedType
Format.Native implementation vs. Format.UserDefined
Formatters for Notification Services 2nd 3rd
Forward-only mode
Fragments 2nd 3rd
FROM clause in FLWOR expressions
FROM OPENROWSET clause
FROM SERVICE clause
FROM SERVICE clause for messaging applications
FROM SERVICE clause for queues
FromBytes method
Functions
Functions, aggregate [See Aggregate functions.]
Functions, CLR
Functions, CLR table-valued
Functions, CLR user-defined
Functions, deterministic
Functions, XML
Functions, XQuery 2nd
FX libraries
GAC (global assembly cache) 2nd
Garbage collection 2nd
Garbage-collected heap
GC class
GenerateRepairWSDL function
Generators in Notification Services 2nd
Geographic Information Systems (GIS)
GET command 2nd 3rd
GET CONVERSATION GROUP statement
get method
get-member cmdlet
GetBits method
GetBytes method
GetBytes method for UDTs
GetBytes method in SqlDataReader
GetChars method
GetCLRControl method
GetCLRManager method
GetColumnInfo method
GetColumnsRowset method
GetConnectionBaseClass2 method
GetConnectStringFromConfigFile method
GetDataSources method
GetDecimal method
GetEstimate method 2nd 3rd 4th
GetEstimateResponse method
GetFactory method
GetFactoryClasses method
GetHashCode method
GetHostManager method
GetInitializedConnectionBaseClass method
GetJobs method
GetKeys method
GetListOfTables method
GetOuterXml method
GetParameterProperties method
GetPropertyObject method
GetProviderFactoryFromUserInput method
GetProviderFromConfigFile method
GetProviderSpecificFieldType method
GetProviderSpecificValue method
GetPubAuth stored procedure
GetResult method
GetRow method 2nd
GetScaled method 2nd
GetSchema method
GetSchema method for metadata 2nd
GetSchema method for restrictions
GetSchema method for table lists
GetSchema method in IXmlSerializable 2nd
GetSchema method in LDim
GetSchema method in SqlConnection
GetSchemaRowset method
GetSchemaTable method 2nd 3rd
GetSmoObject method
GetSqlBinary method
GetSqlBytes method
GetSqlBytes method for UDTs
GetSqlBytes method in SqlDataReader
GetSqlChars method
GetSqlDecimal method
GetSqlString method
GetSqlXml method
GetType method
GetValue method
GetValue method in IDataRecorder
GetValue method in SqlDataReader 2nd 3rd
GetValues method 2nd
GetWSDLUrl function
GetXmlReader method
GIS (Geographic Information Systems)
Global assembly cache (GAC) 2nd
Globally Unique Identifiers [See GUIDs (Globally Unique Identifiers).]
GRANT CONNECT statement
GRANT CREATE XML SCHEMA COLLECTION TO statement
GRANT permission
GRANT statement
Granting permissions
GROUP BY clause
GROUP BY clause with aggregate partitions
GROUP BY clause with XML
groups
Groups conversation
Groups Windows
Guest user
GUIDs (Globally Unique Identifiers)
GUIDs (Globally Unique Identifiers) for assemblies
GUIDs (Globally Unique Identifiers) for brokers 2nd
GUIDs (Globally Unique Identifiers) for conversation endpoints
GUIDs (Globally Unique Identifiers) for conversation groups
GUIDs (Globally Unique Identifiers) for messaging applications
GUIDs (Globally Unique Identifiers) for providers
GUIDs (Globally Unique Identifiers) for routes
HasRows property
HasRows property in DataReader
HasRows property in DbDataReader
Helper functions
Hints, query
Host Protection Attributes (HPAs) 2nd
Hosting
Hosting .NET Framework
Hosting, AppDomain loading for
Hosting, assemblies in
Hosting, assemblies in dependencies
Hosting, assemblies in maintenance
Hosting, assemblies in storing
Hosting, code loading in
Hosting, exception handling in
Hosting, purpose of
Hosting, resource management for
Hosting, safe code in
Hosting, security in
Hosting, specification compliance in
HostProtectionAttribute class
Hot-added memory
HPAs (Host Protection Attributes) 2nd
HTTP
HTTP provider
HTTP, endpoints
HTTP, endpoints, creating 2nd
HTTP, endpoints, declarations
HTTP, endpoints, in SQLXML
HTTP, endpoints, metadata
HTTP, endpoints, SSL for
HTTP, endpoints, states
HTTP, endpoints, URL
HTTP, for Web Services
HTTP, for Web Services, basic authentication
HTTP, for Web Services, connections
HTTP, for Web Services, response
http//www.w3.org/2001/XMLSchema namespace
http//www.w3.org/2001/XMLSchema-instance namespace
httpcfg utility
HTTPS connections
IAlterable interface
IBCPSession interface
IBinarySerialize interface 2nd 3rd 4th 5th 6th
ICommandStream interface
IContentFormatter interface 2nd
ICorRuntimeHost interface
ICreateable interface
IDataReader interface 2nd
IDataRecord interface
IDBCommandWithParameters interface
IDbConnection interface
IDbParameter interface
IDeliveryProtocol interface 2nd
Identity impersonation in Windows
IDispatch interface
IDisposable interface
IDropable interface
IEnumerable interface
IEnumerator interface
IEventProvider interface
IHttpProtocolProvider interface
IL (intermediate language)
ILDasm.EXE (Intermediate Language Disassembler) tool 2nd
IMAGE data type
IMAGE data type for LOBs
IMAGE data type in clients
IMAGE data type vs. MAX
Impersonate method
ImpersonateConnect program
Impersonation of Windows identity
Implicit data type conversions 2nd
Importing types into schemas
Imports directive
IN clause
IN clause with PIVOT
IN clause with UNPIVOT
In-process data access
In-process data access, commands for
In-process data access, connections for
In-process data access, exception handling for
In-process data access, pipes for
In-process data access, return values for
In-process data access, rowsets for
In-process data access, SqlClient for 2nd
In-process data access, SqlContext for
In-process data access, transactions for
In-process data access, triggers for
In-process data access, Web Services from SQLCLR for
In-process data access, WindowsIdentity for
IncludeIfNotExists property
Index buffers
Indexed views
Indexers for SMO objects
Indexes
Indexes for XML data type
Indexes for XQuery
IndexSqlSchema node
Infinite loops
Info property
Information identification for provider factories
Information property
INFORMATION_SCHEMA
INFORMATION_SCHEMA for assemblies
INFORMATION_SCHEMA for metadata
INFORMATION_SCHEMA.ROUTINES view
Infosets
Inheritance in CLR
Init method 2nd
INITIATOR direction for contracts
Injection, guarding against
Inline XSD format schema
Input validation
Input/output parameters for stored procedures
INSERT permission 2nd
INSERT statement
INSERT statement in XML
INSERT statement, CTEs with
INSERT statement, encryption in 2nd
INSERT statement, OUTPUT clause in
INSERT statement, TOP clause in
INSERT statement, with BULK Provider
InsertCommand command
INSERTED table 2nd
Inserting rows
Instance configuration files
Instance members for user-defined types
InstanceName entry
InstanceName property
Instances in CLR type system
INSTEAD OF triggers 2nd
Integral data types in XML
Integrity checking
IntelliSense for SMO 2nd
Intermediate language (IL)
Intermediate Language Disassembler (ILDasm.EXE) tool 2nd
Internal activation in service programs
Interoperability
Interoperability in service-oriented database applications
Interoperability with SqlContext
Реклама