O'Reilly logo

Beginning SQL Server 2008 Administration by Carmen Taglienti, Grant Fritchey, Robert E. Walters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Transact-SQL

Transact-SQL (T-SQL) is the dialect of the Structured Query Language (SQL) adopted by Microsoft's SQL Server database engine. T-SQL has been around since the early days of the Sybase code in the early 1990s. It has evolved throughout the years and today is a robust programming language based on the ANSI SQL:2008 standard. In this chapter, you will learn how to access data using T-SQL statements as well as how to use many of the programming capabilities within the database engine, including stored procedures and functions.

The VetClinic Sample Database Revisited

Before diving in, it is important to revisit the VetClinic database that you created in the previous chapter. You'll use that database for all of the examples in this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required