SQL Server T-SQL Recipes
SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, c...
| Autores principales: | , , , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 4th ed. 2015. |
| Colección: | Expert's voice in SQL server.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629594606719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Getting Started with SELECT""; ""1-1. Connecting to a Database""; ""Problem""; ""Solution""; ""How It Works""; ""1-2. Checking the Database Server Version""; ""Problem""; ""Solution""; ""How It Works""; ""1-3. Checking the Database Name""; ""Problem""; ""Solution""; ""How It Works""; ""1-4. Checking Your Username""; ""Problem""; ""Solution""; ""How It Works""; ""1-5. Querying a Table""; ""Problem""; ""Solution""; ""How It Works""
- ""1-6. Returning Specific Rows""""Problem""; ""Solution""; ""How It Works""; ""1-7. Listing the Available Tables""; ""Problem""; ""Solution""; ""How It Works""; ""1-8. Naming the Output Columns""; ""Problem""; ""Solution""; ""How It Works""; ""1-9. Providing Shorthand Names for Tables""; ""Problem""; ""Solution""; ""How It Works""; ""1-10. Computing New Columns from Existing Data""; ""Problem""; ""Solution""; ""How It Works""; ""1-11. Negating a Search Condition""; ""Problem""; ""Solution""; ""How It Works""; ""1-12. Keeping the WHERE Clause Unambiguous""; ""Problem""; ""Solution""
- ""How It Works""""1-13. Testing for Existence""; ""Problem""; ""Solution""; ""How It Works""; ""1-14. Specifying a Range of Values""; ""Problem""; ""Solution""; ""How It Works""; ""1-15. Checking for Null Values""; ""Problem""; ""Solution""; ""How It Works""; ""1-16. Writing an IN- List""; ""Problem""; ""Solution""; ""How It Works""; ""1-17. Performing Wildcard Searches""; ""Problem""; ""Solution""; ""How It Works""; ""1-18. Sorting Your Results""; ""Problem""; ""Solution""; ""How It Works""; ""1-19. Specifying the Case-Sensitivity of a Sort""; ""Problem""; ""Solution""; ""How It Works""
- ""1-20. Sorting Nulls High or Low""""Problem""; ""Solution""; ""How It Works""; ""1-21. Forcing Unusual Sort Orders""; ""Problem""; ""Solution""; ""How It Works""; ""1-22. Paging Through a Result Set""; ""Problem""; ""Solution""; ""How It Works""; ""1-23. Sampling a Subset of Rows""; ""Problem""; ""Solution""; ""How It Works""; ""Chapter 2: Elementary Programming""; ""2-1. Executing T-SQL from a File""; ""Problem""; ""Solution""; ""How It Works""; ""2-2. Retrieving Values into Variables""; ""Problem""; ""Solution""; ""How It Works""; ""2-3. Writing Expressions""; ""Problem""; ""Solution""
- ""How It Works""""2-4. Deciding Between Two Execution Paths""; ""Problem""; ""Solution""; ""How It Works""; ""2-5. Detecting Whether Rows Exist""; ""Problem""; ""Solution""; ""How It Works""; ""2-6. Going to a Label in a Transact-SQL Batch""; ""Problem""; ""Solution""; ""How It Works""; ""2-7. Trapping and Throwing Errors""; ""Problem""; ""Solution""; ""How It Works""; ""2-8. Returning from the Current Execution Scope""; ""Problem""; ""Solution #1: Exit with No Return Value""; ""Solution #2: Exit and Provide a Value""; ""How It Works""; ""2-9. Writing a Simple CASE Expression""; ""Problem""
- ""Solution""
