Beginning T-SQL with Microsoft® SQL Server® 2005 and2008
Nearly all business applications read, store, and manipulatedata stored in relational databases. If you use Microsoft SQLServer in any way, you need to learn and use T-SQL,?Microsoft'spowerful implementation of the ANSI-standard SQL database querylanguage.
This book teaches all of the basics of T-SQL as it's used withSQL Server 2005 and 2008 databases. The authors, leading T-SQLexperts, begin with the essentials of SQL Server that are needed toget the most from T-SQL. They then quickly move on to introduceT-SQL itself, including the core elements of data retrieval, SQLfunctions, aggregation and grouping, and multi-table queries, andthey fully explain transaction processing and data manipulationusing T-SQL.
The authors also show you how to create and manage T-SQLprogramming objects, including views, functions, and storedprocedures. They detail how to optimize T-SQL query performance anddesign queries for real-world business applications. All of themethods and techniques in this book can be used with both MicrosoftSQL Server 2005 and 2008 databases.
In addition, the book includes a comprehensive set of referenceappendices, including T-SQL command syntax, system variables andfunctions, system stored procedures, information schema views, andFileStream objects.
What you will learn from this book
How to add, modify, and remove records
How to query multiple tables
Ways to use views to modify data
How to create tools for managing databases using T-SQL
T-SQL programming techniques using views, user-definedfunctions, and stored procedures
Methods for optimizing?query performance
How to use?SQL Server Reporting Services to visualize T-SQLquery results
Who this book is for
This book is for beginning SQL Server developers andadministrators who need to learn how to use T-SQL. Basicfamiliarity with relational databases and a general understandingof?basic SQL functions is necessary.
Wrox Beginning guides
are crafted to make learningprogramming languages and technologies easier than you think,providing a structured, tutorial format that will guide you throughall the techniques involved.