SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
Book format: An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.
Publisher: Date:12/6/2005 - Apress
By: Joseph Sack
If you are looking for a succinct, easy to use, and up-to-date reference guide for SQL Server 2005 and T-SQL, I highly recommend SQL Server 2005 T-SQL Recipes. — David Hayden, .NET Developer Each chapter is completely autonomous, so you can just look up the syntax you need at the time without having to rely on knowledge from previous chapters. Its really an excellent reference that deserves a place on your desk. — Sean McCown, ITBookworm Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL&emdash:related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer. This "no-fluff" desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory. Additionally, this book provides "how-to" answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.