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