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 1114 and 2730. 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.