Transact SQL (TSQL) code is used to maintain and unlock the knowledge of data stored in a SQL Server. The TSQL language is a proprietary version of the SQL language developed by Microsoft. TSQL is used to maintain, manipulate and report on data stored in SQL Server. This book will cover different aspects of the TSQL language. With an understanding the basics of the TSQL language, programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.
This book takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples. The basics of the TSQL language are explored first, by starting with the SELECT statement. As the reader progresses through each chapter, they will learn about how to, join, sort, group, and aggregate data. In addition to the basic programming topics, this book also covers the history of SQL Server and basics of set theory. By the end of the book, the readers will have a good foundation of how to write SELECT, UPDATE, INSERT and DELETE statements to manipulate SQL Server data.