When it comes to performing your daily SQL Server tasks, technical documentation tends to tell you morethan you need to know. Let’s say that you’re in ahurry, and you want to add a unique constraint to atable before someone inserts aduplicate value into it. Where do you look?
One obvious choice is SQL Server Books Online. With its massive amounts of useful information, you know that the answer has to be there somewhere. Unfortunately, finding this information may involve several click-throughs and red herrings. Once you doarrive at the correct page, the information you need may be integrated into alarger syntax block, with unrelated functionality or examples.
SQL Server 2005 T-SQL Recipeswas written in order to address the need for fast information retrieval and use. Topics are presented in atask-based format. Each topic (recipe) provides the necessary background to get you started, presents one or more examples, and then concisely explains how it all works.