Авторизация
Поиск по указателям
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
Предметный указатель
user_name function
UseWaitHandles method
using directive 2nd
using directive for row insertions
using directive for subscribers
using directive for transactions
UTF-16 code 2nd
ValidateFullNull function
ValidateSSN function
ValidateSSNFull function
ValidateSSNFullNull function
ValidateSSNTSQL function 2nd
Validation
Validation for message types 2nd
Validation for UDTs
Validation for user libraries
Validation XML 2nd
ValidationFunctions class
ValidationMethodName property
VALID_XML validation
Value comparison operators
VALUE indexes 2nd
value method 2nd
Value property
Value property for SMO objects
Value property in SqlTypes
ValueType class
VAR function
VARBINARY data type
VARBINARY data type in clients
VARBINARY data type in messaging applications
VARBINARY data type in SQLXML
VARBINARY data type in XML 2nd
VARBINARY data type vs. MAX
VARBINARY data type, maximum size for
VARCHAR data type
VARCHAR data type for SqlTypes
VARCHAR data type in clients
VARCHAR data type in messaging applications
VARCHAR data type in SQLXML
VARCHAR data type in Visual Studio
VARCHAR data type in XML 2nd 3rd
VARCHAR data type maximum size for
VARCHAR data type with MAX
VARCHAR data type with OpenXML
Variables
Variables UDT
Variables XML 2nd
verbose flag in Update command
Versioning in SNAPSHOT isolation
Versioning in SNAPSHOT isolation, drawbacks of
Versioning in SNAPSHOT isolation, monitoring
Versions for assemblies
VIEW DEFINITION permission
Virtual memory
Visibility
Visibility in CLR type system
Visibility of classes
Visual Basic null values
Visual Studio
Visual Studio for connection information
Visual Studio for Notification Services
Visual Studio, attributes in
Visual Studio, automatic deployment in
Visual Studio, data types and SqlFacet in
Visual Studio, executing and debugging code in
void data type
WAIT FOR clause 2nd
WaitAll method
WaitAny method
WaitHandles method
WatchDirectory argument
Watching rowsets
Web Service Definition Language (WSDL)
Web Service Definition Language (WSDL), generation process
Web Service Definition Language (WSDL), working with
Web Services
Web Services and marshaling data
Web Services from SQLCLR
Web Services, best practices
Web Services, HTTP endpoints
Web Services, HTTP endpoints, creating
Web Services, HTTP endpoints, declarations
Web Services, HTTP endpoints, in SQLXML
Web Services, HTTP endpoints, metadata
Web Services, HTTP endpoints, SSL for
Web Services, HTTP endpoints, states
Web Services, HTTP endpoints, URL
Web Services, proxy classes
Web Services, SQL batches
Web Services, SQLXML for [See SQLXML.]
Web Services, SSL for
Web Services, stored procedures for
Web Services, Webmethods
Web Services, WSDL for
Web Services, WSDL for generation process
Web Services, WSDL for working with
Web Services, XML namespaces for
WEBMETHOD clause 2nd 3rd
Webmethods
WebRequest class
Well-formedness rules
WELL_FORMED_XML validation 2nd 3rd
WHERE clause
WHERE clause in DELETE
WHERE clause in XQuery
WHERE EXISTS clause
WHERE NOT EXISTS clause
Whitespace entitization
Wildcards
Wildcards in OUTPUT
Wildcards in XML 2nd
Windows groups
Windows identity impersonation
Windows Management Instrumentation (WMI)
Windows XP Support Tools
WindowsIdentity property
WindowsIdentity property for in-process data access
WindowsIdentity property in SqlContext
WindowsImpersonationContext
WITH ACTIVATION clause 2nd
WITH CLEANUP clause
WITH ERROR clause
WITH EXECUTE AS clause 2nd
WITH keyword for CTEs
WITH RELATED_CONVERSATION_GROUP clause
WITH RETENTION clause
WITH SCHEMA COLLECTION clause
WITH SCHEMABINDING clause 2nd 3rd
WITH TIES clause
WITH XMLNAMESPACES clause
WithDependencies option
WithEvents keyword
WITHOUT LOGIN clause
WMI (Windows Management Instrumentation)
WMI CIM Studio tool
Wmi class
Write method
Write method in IBinarySerialize
Write method in LDim 2nd
Write method in MAX
Write method in XML
WriteLine method
WriteSchema method
WRITETEXT method
WriteXml method
WriteXml method in DataSet
WriteXml method in IXmlSerializable
WriteXml method in LDim
Ws-Security specification
WSDL (Web Service Definition Language)
WSDL (Web Service Definition Language), generation process
WSDL (Web Service Definition Language), working with
WSDLComplex query strings 2nd
WSDLMinimal query string 2nd
WSDLSimple query strings 2nd
wsdl_generator_procedure
X.509 certificates 2nd
XACT_ABORT function
XACT_STATE function
XDR format schema
xdt:anyAtomicType data type
xdt:untyped data type
xdt:untypedAtomic data type 2nd 3rd
XLINQ language
XML and XML data type 2nd
XML and XML data type as marshaling format
XML and XML data type for columns
XML and XML data type for inserting data
XML and XML data type for showplans 2nd
XML and XML data type for variables and parameters
XML and XML data type in service-oriented database applications
XML and XML data type in SQLXML
XML and XML data type in SQLXML, indexes for
XML and XML data type in SQLXML, loading from files
XML and XML data type in SQLXML, mapping
XML and XML data type in SQLXML, namespaces in 2nd
XML and XML data type on clients 2nd
XML and XML data type on clients as string
XML and XML data type on clients documents, fragments, and FOR XML support
XML and XML data type on clients in ADO
XML and XML data type on clients in ADO.NET
XML and XML data type, ANSI SQL standard compliance for
XML and XML data type, best practices
XML and XML data type, conversions with 2nd
XML and XML data type, functions
XML and XML data type, OpenXML enhancements
XML and XML data type, overview
XML and XML data type, producing
XML and XML data type, query languages for [See XPath query language; ; XQuery query language.]
XML and XML data type, schemas in
XML and XML data type, schemas in collections
XML and XML data type, schemas in for Notification Services
XML and XML data type, schemas in in XQuery 2nd
XML and XML data type, SELECT with [See FOR XML clause.]
XML and XML data type, streams in
XML and XML data type, typed
XML and XML data type, with UDTs
XML for Analysis
XML Schema Definition language (XSD) standard 2nd 3rd
XML Schema Definition language (XSD) standard, data types in
XML Schema Definition language (XSD) standard, inline format schema
XML Schema Definition language (XSD) standard, restrictions in
xml.nodes function
XML/XSLT formatter
XmlDocument class
XmlElement function
XmlForest function
XmlIgnore attribute
XmlNavigator model
xmlns attribute
XMLPARSE method
XmlReader class 2nd 3rd 4th
XmlReaderSettings class
XMLSERIALIZE method
XmlSerializer class
XmlSerializerAssembly attribute
XmlSerializerContract class
XmlSerializers.dll file
XmlWriter class 2nd
xml_schema_namespace function
XPath data() function
XPath query language 2nd
XPath query language for SMO objects
XPath query language in SQLXML
XPath query language, expressions in
XPathNavigator class
xp_cmdshell program
xp_sendmail program
XQuery 1.0 and XPath 2.0 Data Model specification
XQuery 1.0 and XPath 2.0 Functions and Operators Version 1.0 specification
XQuery query language
XQuery query language in service-oriented database applications
XQuery query language vs. SQL
XQuery query language vs. XSLT
XQuery query language with XML data type
XQuery query language with XML data type, exist method
XQuery query language with XML data type, functions
XQuery query language with XML data type, nodes method
XQuery query language with XML data type, query method
XQuery query language with XML data type, typed
XQuery query language with XML data type, value method
XQuery query language, best practices
XQuery query language, bodies in
XQuery query language, functions in
XQuery query language, indexes in
XQuery query language, inside SQL Server
XQuery query language, introduction
XQuery query language, multiple-document queries in
XQuery query language, operators in
XQuery query language, optimizing
XQuery query language, overview
XQuery query language, prologs in
XQuery query language, schemas in
XQuery query language, updating XML columns
xs prefix
xs:date data type
xs:double data type
xs:maxOccurs facet
xs:minOccurs facet
xs:pattern facet
xs:string data type
xs:time data type
xs:timestamp data type
XSD (XML Schema Definition language) standard 2nd 3rd
XSD (XML Schema Definition language) standard, data types in
XSD (XML Schema Definition language) standard, inline format schema
XSD (XML Schema Definition language) standard, restrictions in
xsd:annotations data type
xsd:any data type
xsd:base64Binary data type 2nd
xsd:dateTime data type
xsd:decimal data type
xsd:hexBinary data type
xsd:integer data type
xsd:length facet
xsd:maxLength facet
xsd:string data type
xsi:nil attribute 2nd
xsi:prefix
xsi:schemaLocation attribute 2nd
xsi:type attribute
XSL transform for Notification Services
XSLT (Extensible Stylesheet Language Transformations) 2nd
XsltFormatter tool 2nd
yield return instruction 2nd
Реклама