Chapter 4: Introduction to Transact-SQL Programming

Overview

Transact-SQL is Microsoft's implementation of SQL, and it contains additional programming constructs. (It's often shortened to T-SQL, a convention you'll see in this chapter.) T-SQL enables you to write programs that contain SQL statements, along with standard programming constructs such as variables, conditional logic, loops, procedures, and functions.

Featured in this chapter:

  • Fundamentals of Transact-SQL

  • Using functions

  • Creating user-defined functions

  • Introducing stored procedures

  • Introducing triggers




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net