Cover image for Microsoft SQL server 2008 : T-SQL fundamentals
Title:
Microsoft SQL server 2008 : T-SQL fundamentals
Author:
Ben-Gan, Itzik.
ISBN:
9780735626010
Personal Author:
Publication Information:
Redmond, Wash. : Microsoft Press, ©2009.
Physical Description:
xviii, 394 pages : illustrations ; 23 cm
General Note:
Includes index.
Contents:
Background to T-SQL querying and programming -- Single-table queries -- Joins -- Subqueries -- Table expressions -- Set operations -- Pivot, unpivot, and grouping sets -- Data modification -- Transactions and concurrency -- Programmable objects.
Abstract:
"Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance - including exercises and code samples - that show you how to develop code to query and modify data. You'll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries."--Jacket.