Pro T SQL Programmer S Guide
User Manual:
Open the PDF directly: View PDF
Page Count: 818 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Title
- Copyright
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: Foundations of T-SQL
- Chapter 2: Tools of the Trade
- Chapter 3: Procedural Code
- Chapter 4: User-Defined Functions
- Chapter 5: Stored Procedures
- Chapter 6: In-Memory Programming
- Chapter 7: Triggers
- Chapter 8: Encryption
- Chapter 9: Common Table Expressions and Windowing Functions
- Chapter 10: Data Types and Advanced Data Types
- Chapter 11: Full-Text Search
- FTS Architecture
- Creating Full-Text Catalogs and Indexes
- Creating Full-Text Catalogs
- Creating Full-Text Indexes
- Full-Text Querying
- The FREETEXT Predicate
- FTS Performance Optimization
- The CONTAINS Predicate
- The FREETEXTTABLE and CONTAINSTABLE Functions
- Thesauruses and Stoplists
- Stored Procedures and Dynamic Management Views and Functions
- Statistical Semantics
- Summary
- FTS Architecture
- Chapter 12: XML
- Legacy XML
- OPENXML
- OPENXML Result Formats
- FOR XML Clause
- FOR XML RAW
- FOR XML AUTO
- FOR XML EXPLICIT
- FOR XML PATH
- The xml Data Type
- Untyped xml
- Typed xml
- The xml Data Type Methods
- The query Method
- The value Method
- The exist Method
- The nodes Method
- The modify Method
- XML Indexes
- XSL Transformations
- SQL CLR Security Settings
- Summary
- Chapter 13: XQuery and XPath
- XPath and FOR XML PATH
- XPath Attributes
- Columns without Names and Wildcards
- Element Grouping
- The data Function
- Node Tests and Functions
- XPath and NULL
- The WITH XMLNAMESPACES Clause
- Node Tests
- XQuery and the xml Data Type
- Expressions and Sequences
- The query Method
- Location Paths
- Node Tests
- Namespaces
- Axis Specifiers
- Dynamic XML Construction
- XQuery Comments
- Data Types
- Predicates
- Value Comparison Operators
- General Comparison Operators
- Xquery Date Format
- Node Comparisons
- Conditional Expressions (if...then...else)
- Arithmetic Expressions
- Integer Division in XQuery
- XQuery Functions
- Constructors and Casting
- FLWOR Expressions
- The for and return Keywords
- The where Keyword
- The order by Keywords
- The let Keyword
- UTF-16 Support
- Summary
- XPath and FOR XML PATH
- Chapter 14: Catalog Views and Dynamic aent Views
- Chapter 15: .NET Client Programming
- ADO.NET
- The .NET SQL Client
- Connected Data Access
- Disconnected Datasets
- Parameterized Queries
- Nonquery, Scalar, and XML Querying
- SqIBulkCopy
- Multiple Active Result Sets
- LINQ to SQL
- Using the Designer
- Querying with LINQ to SQL
- Basic LINQ to SQL Querying
- Deferred Query Execution
- From LINQ to Entity Framework
- Querying Entities
- Summary
- Chapter 16: CLR Integration Programming
- Chapter 17: Data Services
- Chapter 18: Error Handling and Dynamic SQL
- Chapter 19: Performance Tuning
- Appendix A: Exercise Answers
- Appendix B: XQuery Data Types
- Appendix C: Glossary
- ACID
- adjacency list model
- ADO.NET Data Services
- anchor query
- application programming interface (API)
- assembly
- asymmetric encryption
- atomic, list, and union data types
- axis
- Bulk Copy Program (BCP)
- catalog view
- certificate
- check constraint
- closed-world assumption (CWA)
- clustered index
- comment
- computed constructor
- content expression
- context item expression
- context node
- database encryption key
- database master key
- data domain
- data page
- datum
- empty sequence
- entity data model (EDM)
- Extended Events (XEvents)
- extensible key management (EKM)
- extent
- Extract, Transform, Load (ETL)
- facet
- filter expression
- FLWOR expression
- foreign key constraint
- full-text catalog
- full-text index
- full-text search (FTS)
- Functions and Operators (F&O)
- general comparison
- Geography Markup Language (GML)
- grouping set
- hash
- heap
- heterogeneous sequence
- homogenous sequence
- indirect recursion
- inflectional forms
- initialization vector (IV)
- Language Integrated Query (LINQ)
- location path
- logon trigger
- materialized path model
- Multiple Active Result Sets (MARS)
- nested sets model
- node
- node comparison
- node test
- nonclustered index
- object-relational mapping (O/RM)
- open-world assumption (OWA)
- optional occurrence indicator
- parameterization
- path expression
- predicate
- predicate truth value
- primary expression
- query plan
- recompilation
- recursion
- row constructor
- scalar function
- searched CASE expression
- sequence
- server certificate
- service master key (SMK)
- shredding
- simple CASE expression
- SOAP
- spatial data
- spatial index
- SQL Server Data Tools
- SQL injection
- step
- table type
- three-valued logic (3VL)
- transparent data encryption (TDE)
- untyped XML
- user-defined aggregate (UDA)
- user-defined type (UDT)
- value comparison
- well-formed XML
- well-known text (WKT)
- windowing functions
- World Wide Web Consortium (W3C)
- XML
- XML schema
- XPath
- XQuery
- XQuery/XPath Data Model (XDM)
- XSL
- XSLT
- Appendix D: SQLCMD Quick Reference
- Index