SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach
- ISBN-10
- 1430242019
- ISBN-13
- 9781430242017
- Category
- Computers
- Pages
- 808
- Language
- English
- Published
- 2012-10-15
- Publisher
- Apress
- Authors
- David Dye, Timothy Roberts, Jonathan Gennick
Description
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains
Get the book
Other editions
Similar books
-
SQL Server T-SQL Recipes
By David Dye, Timothy Roberts, Jonathan GennickThis edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks.
-
Microsoft SQL Server 2012 Performance Tuning Cookbook
By Ritesh ShahOver 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.
-
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
By Joseph Sack* Comprehensive T-SQL Coverage, including all SQL Server 2005 new features, from an established SQL Server expert and author. * Broad appeal, with practical ‘How to’ answers to common SQL Server T-SQL questions for both novice and ...
-
Transact-SQL Cookbook: Help for Database Programmers
By Ales Spetic, Jonathan GennickJonathan Gennick is a writer and editor with extensive database and programming experience. He has written or contributed to a number of database-related books, including Oracle SQL*Loader: The Definitive Guide and Oracle SQL*Plus: The ...
-
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
By Joseph SackWithout Transact-SQL, there is nothing.
-
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools
By Adam AspinIf you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.
-
Microsoft SQL Server 2012 T-SQL Fundamentals
By Itzik Ben-GanGain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012.
-
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
By Reza Rad, Pedro PerfeitoOver 100 expert recipes to design, create, and deploy SSIS packages with this book and ebook.
-
Beginning Microsoft SQL Server 2012 Programming
By Paul Atkinson, Robert VieiraBeginning Microsoft SQL Server 2012 Programming: Explores the key concepts for developing SQL Server applications, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint® and ...
-
Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports
By Paul Turley, Robert M. BrucknerIf so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face.