Wiley Beginning Transact-SQL with SQL Server 2000 and 2005 978-0-7645-7955-4 ユーザーズマニュアル
製品コード
978-0-7645-7955-4
1
Introducing Transact-SQL
and Data Management
Systems
Welcome to the world of Transact-Structured Query Language programming. Transact-SQL, or
T-SQL, is Microsoft Corporation’s implementation of the Structured Query Language, which
was designed to retrieve, manipulate, and add data to Relational Database Management Systems
(RDBMS). Hopefully, you already have a basic idea of what SQL is used for because you pur-
chased this book, but you may not have a good understanding of the concepts behind relational
databases and the purpose of SQL. This first chapter introduces you to some of the fundamentals
of the design and architecture of relational databases and presents a brief description of SQL as
a language. If you are brand new to SQL and database technologies, this chapter will provide a
foundation to help ensure the rest of the book is as effective as possible. If you are already comfort-
able with the concepts of relational databases and Microsoft’s implementation, specifically, you
may want to skip on ahead to Chapter 2, “SQL Server Fundamentals,” or Chapter 3, “Tools for
Accessing SQL Server.” Both of these chapters introduce some of the features and tools in SQL
Server 2000 as well as the new features and tools coming with SQL Server 2005.
T-SQL, is Microsoft Corporation’s implementation of the Structured Query Language, which
was designed to retrieve, manipulate, and add data to Relational Database Management Systems
(RDBMS). Hopefully, you already have a basic idea of what SQL is used for because you pur-
chased this book, but you may not have a good understanding of the concepts behind relational
databases and the purpose of SQL. This first chapter introduces you to some of the fundamentals
of the design and architecture of relational databases and presents a brief description of SQL as
a language. If you are brand new to SQL and database technologies, this chapter will provide a
foundation to help ensure the rest of the book is as effective as possible. If you are already comfort-
able with the concepts of relational databases and Microsoft’s implementation, specifically, you
may want to skip on ahead to Chapter 2, “SQL Server Fundamentals,” or Chapter 3, “Tools for
Accessing SQL Server.” Both of these chapters introduce some of the features and tools in SQL
Server 2000 as well as the new features and tools coming with SQL Server 2005.
Another great, more in-depth source for SQL 2000 and SQL 2005 programming from the appli-
cation developer’s perspective are the Wrox Press books authored by Rob Viera: Professional
SQL Server 2000 Programming, Beginning SQL Server 2005 Programming, and
Professional SQL Server 2005 Programming. Throughout the chapters ahead, I will refer back
to both the basic concepts introduced in this chapter and to areas in the books mentioned here for
further clarification in the use or nature of the Transact-SQL language.
cation developer’s perspective are the Wrox Press books authored by Rob Viera: Professional
SQL Server 2000 Programming, Beginning SQL Server 2005 Programming, and
Professional SQL Server 2005 Programming. Throughout the chapters ahead, I will refer back
to both the basic concepts introduced in this chapter and to areas in the books mentioned here for
further clarification in the use or nature of the Transact-SQL language.
Transact-Str uctured Quer y Language
T-SQL is Microsoft’s implementation of a standard established by the American National
Standards Institute (ANSI) for the Structured Query Language (SQL). SQL was first developed by
researchers at IBM. They called their first pre-release version of SQL “SEQUEL,” which stood for
S
Standards Institute (ANSI) for the Structured Query Language (SQL). SQL was first developed by
researchers at IBM. They called their first pre-release version of SQL “SEQUEL,” which stood for
S
tructured English QUEry Language. The first release version was renamed to SQL, dropping the
04_57955x ch01.qxd 9/19/05 12:43 PM Page 1
COPYRIGHTED MATERIAL