Related Posts (1)

Fundamental T-SQL Script

By MEBRATU Sun Dec 16, 2018 at 08:34 PM (5 years ago)
Updated On Fri Nov 04, 2022 at 03:08 PM (2 years ago)

                      This book walks you through your first steps in T-SQL (also known as Transact-SQL), which is the Microsoft SQL Server dialect of the ISO and ANSI standards for SQL.
You’ll learn the theory behind T-SQL querying and programming and how to develop
T-SQL code to query and modify data, and you’ll get an overview of programmable
objects.
Although this book is intended for beginners, it is not merely a set of procedures
for readers to follow. It goes beyond the syntactical elements of T-SQL and explains the
logic behind the language and its elements.
Occasionally, the book covers subjects that may be considered advanced for readers
who are new to T-SQL; therefore, those sections are optional reading. If you already feel
comfortable with the material discussed in the book up to that point, you might want
to tackle the more advanced subjects; otherwise, feel free to skip those sections and return to them after you’ve gained more experience. The text will indicate when a section
may be considered more advanced and is provided as optional reading.
Many aspects of SQL are unique to the language and are very different from other
programming languages. This book helps you adopt the right state of mind and gain a
true understanding of the language elements. You learn how to think in terms of sets
and follow good SQL programming practices.
The book is not version-specific; it does, however, cover language elements that
were introduced in recent versions of SQL Server, including SQL Server 2012. When I
discuss language elements that were introduced recently, I specify the version in which
they were added