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 ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.