SQL for .net Programmers: Moving Beyond Select, Insert, Update, Delete Without Becoming a Dba

Description

Who’s got time to read? There’s code to write! Are you a programmer? Do you hate to read more than you have to? Then this book is definitely for you. Each topic in this book is covered in just a few pages. But what it covers will set you on your way to programming using T-SQL. This book is for programmers. There are plenty of really thick books that go into all the details about each of the subjects that are covered in this book. But if you spend most of your day in languages like C#, those books have way more information than you need. The result is, you’ll probably never find the information that would really help you in your day to day programming life because you are more likely to space out while reading, or you’ll simply gloss over the important points trying to find the important points. Let’s face it, you know you should know more about SQL than you do, but right now you don’t even know what you don’t know. And so this book is intended to be a survey of SQL. Lots of short little chapters that tell you just what you need to know to be productive. It doesn’t wade you down in every tiny detail of every syntax quirk. This isn’t to say that there aren’t tips along the way.While this book isn’t big, it is dense. Code should be concise. So should the books that teach you how to code. The intention of this book is to provide a lot of value in as little space as possible. You don’t have time to read stuff you’ll never use and providing a book with fluff in it just to get the page count up would only serve as a marketing gimmick. So, if you are looking for the fastest way to learn the essence of SQL, read on. If you were looking for something with more detail, or more pages, this isn't the book for you. Who is This Book for? How to Use This Book Why Bother? Running SQL from .NET CREATE/DROP Database CREATE TABLE ALTERing the TABLE Basic SQL Commands Finding a String Finding IN a List JOINS LEFT OUTER JOIN RIGHT OUTER JOIN INNER JOIN FULL OUTER JOIN CROSS JOIN GROUP BY HAVING UNIONs Filtering on two rows Stored Procedures Stored Procedure Basics SQL IF Blocks SQL WHILE Temporary Tables SQL CURSOR SQL CURSOR Performance Return Random Records VIEWS FUNCTIONS TRIGGERS Testing Version Control Resources