SQL Server T-SQL recipes. (2015)

• Record Type: Book
• 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 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""
• 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.