Beginning T-sql
by Kathi Kellenberger /
2017 / English / PDF
19.7 MB Download
If you are reading this book, you probably already know something about T-SQL. T-SQL, also known as Transact-SQL, is Microsofts implementation of the Structured Query Language (SQL) for SQL Server. T-SQL is the language that is most often used to extract or modify data stored in an SQL Server database, regardless of which application or tool you use. SQL Server 2014 T-SQL is based on standards created by the American National Standards Institute (ANSI), but Microsoft has added several functionality enhancements. You will find that T-SQL is a very versatile and powerful programming language. T-SQL consists of Data Definition Language (DDL), Data Manipulation Language (DML), and control-of-flow statements. Although the book focuses primarily on the DML statements, which you will use to retrieve and manipulate data, this book covers DDL statements and programming logic as well. This chapter will explain how to install a free edition of SQL Server and get it ready for running the example code and performing the exercises in the rest of this book. This chapter also gives you a quick tour of SQL Server Management Studio.
