SQL Server T-SQL Recipes

SQL Server T-SQL Recipes

<p><em>SQL Server T-SQL Recipes</em> 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, create in-memory tables and stored procedures, 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. </p><p>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, managing indexes, error handling, and query performance. 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.</p><ul><li>Focused on solutions: Look up what you need to do. Learn how to do it. Do it.</li><li>Current: Lightly updated for SQL Server 2014</li><li>Comprehensive: Covers all common T-SQL problem domains</li></ul>