O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

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

LESSON 27An Introduction to Transact-SQL

This lesson’s material covers the Transact-SQL language, which is a supplement to the accepted SQL standard. This lesson’s goals are to

• Identify one of the more popular extensions to SQL: Transact-SQL

• Outline the major features of Transact-SQL

• Provide practical examples to give you an understanding of how Transact-SQL is used

An Overview of Transact-SQL

Lesson 19, “Temporary Tables, Stored Procedures, Triggers, and Cursors,” briefly covers static SQL. The examples in Lesson 19 depict the use of embedded SQL in third-generation programming languages such as C. With this method of programming, the embedded SQL code does not change and is therefore limited. On the other hand, you can write dynamic ...

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