SQL Server T-SQL recipes. (2015)
- Record Type:
- Book
- Title:
- SQL Server T-SQL recipes. (2015)
- Main Title:
- SQL Server T-SQL recipes
- Further Information:
- Note: Jason Brimhall, Jonathan Gennick, Wayne Sheffield.
- Authors:
- Brimhall, Jason
Gennick, Jonathan
Sheffield, Wayne - Contents:
- ""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""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"" … (more)
- Edition:
- Fourth edition
- Publisher Details:
- Berkeley, CA : Apress
- Publication Date:
- 2015
- Copyright Date:
- 2015
- Extent:
- 1 online resource (lxxix, 972 pages), illustrations
- Subjects:
- 005.75/85
Computer science
SQL (Computer program language)
COMPUTERS -- Programming Languages -- SQL
SQL (Computer program language)
Computers -- Programming Languages -- General
Programming & scripting languages: general
Database management
Computers -- Database Management -- General
Databases
Electronic books - Languages:
- English
- ISBNs:
- 9781484200612
1484200616
1484200624
9781484200629 - Related ISBNs:
- 9781484200629
- Notes:
- Note: Online resource; title from PDF title page (SpringerLink, viewed July 20, 2015).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.374798
- Ingest File:
- 02_355.xml