Pro T-SQL 2012 programmer's guide
Pro T–SQL 2012 Programmer’s Guide is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable so...
| Other Authors: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
[Berkeley, Calif.] :
Apress
2012.
|
| Edition: | 3rd ed |
| Series: | The expert's voice in SQL server Pro T-SQL 2012 programmer's guide
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628577506719 |
Table of Contents:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Introduction; Whom This Book Is For; How This Book Is Structured; Conventions; Prerequisites; Apress Website; CHAPTER 1 Foundations of T-SQL; A Short History of T-SQL; Imperative vs. Declarative Languages; SQL Basics; Statements; Databases; Transaction Logs; Schemas; Tables; Views; Indexes; Stored Procedures; User-Defined Functions; SQL CLR Assemblies; Elements of Style; Whitespace; Naming Conventions; One Entry, One Exit; Defensive Coding
- The SELECT * StatementVariable Initialization; Summary; CHAPTER 2 Tools of the Trade; SQL Server Management Studio; IntelliSense; Code Snippets; Keyboard Shortcut Schemes; T-SQL Debugging; SSMS Editing Options; Context-Sensitive Help; Graphical Query Execution Plans; Project Management Features; The Object Explorer; The SQLCMD Utility; SQL Server Data Tools; SQL Profiler; Extended Events; SQL Server Integration Services; The Bulk Copy Program; SQL Server 2012 Books Online; The AdventureWorks Sample Database; Summary; CHAPTER 3 Procedural Code and CASE Expressions; Three-Valued Logic
- Control-of-Flow StatementsThe BEGIN and END Keywords; The IF. . .ELSE Statement; The WHILE, BREAK, and CONTINUE Statements; The GOTO Statement; The WAITFOR Statement; The RETURN Statement; The CASE Expression; The Simple CASE Expression; The Searched CASE Expression; CASE and Pivot Tables; The IIF Statement; CHOOSE; COALESCE and NULLIF; Cursors; Summary; CHAPTER 4 User-Defined Functions; Scalar Functions; Recursion in Scalar User-Defined Functions; Procedural Code in User-Defined Functions; Multistatement Table-Valued Functions; Inline Table-Valued Functions
- Restrictions on User-Defined FunctionsNondeterministic Functions; State of the Database; Summary; CHAPTER 5 Stored Procedures; Introducing Stored Procedures; Metadata Discovery; Calling Stored Procedures; Managing Stored Procedures; Stored Procedures Best Practices; Stored Procedure Example; Recursion in Stored Procedures; Table-Valued Parameters; Temporary Stored Procedures; Recompilation and Caching; Stored Procedure Statistics; Parameter Sniffing; Recompilation; Summary; CHAPTER 6 Triggers; DML Triggers; When to Use DML Triggers; Auditing with DML Triggers; Nested and Recursive Triggers
- The UPDATE() and COLUMNS_UPDATED() FunctionsTriggers on Views; DDL Triggers; Logon Triggers; Summary; CHAPTER 7 Encryption; The Encryption Hierarchy; Service Master Keys; Database Master Keys; Certificates; Asymmetric Keys; Symmetric Keys; Encryption without Keys; Hashing Data; Extensible Key Management; Transparent Data Encryption; Summary; CHAPTER 8 Common Table Expressions and Windowing Functions; Common Table Expressions; Multiple Common Table Expressions; Recursive Common Table Expressions; Window Functions; ROW_NUMBER Function; Query Paging with OFFSET/FETCH
- The RANK and DENSE_RANK Functions
