Chapter 26. Using Transact-SQL in SQL Server 2000
by Ray Rankins
IN THIS CHAPTER
T-SQL and ANSI/ISO SQL
What's New for T-SQL in SQL Server 2000
SELECT, INSERT, UPDATE, and DELETE
SQL Server Functions
Programming Constructs
Cursors
The intent of this chapter is to provide an overview of the elements of the Transact-SQL (T-SQL) language. The focus is primarily on the Data Manipulation Language (DML) com-mands and the programming constructs built into T-SQL. The various Data Definition Language (DDL) commands are covered in other chapters, primarily Chapters 11–14 and 27–30. This chapter is not intended as a learning tool for the general SQL language. Several such books are on the market, from beginning to advanced levels; some describe the standard ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.