5.7. INTRODUCTION TO TRANSACT-SQL PROGRAMMING

Transact-SQL (T-SQL) is the programming language by which all applications communicate with SQL Server. Users may issue interactive T-SQL programs via applications such as Query Analyzer and osql.

Transact-SQL consists of

  • Fourth Generation Language (4GL) SQL composed of the DDL and DML statements discussed elsewhere throughout this book

  • 3GL programming constructs described here including local variables, IF-ELSE, and looping. There is great value in having 3GL features available in T-SQL in that when these powerful 3GL constructs are needed, the data does not have to be transferred from the database engine to an external 3GL program written in a language such as C / C++, Visual Basic, Perl, etc. The ...

Get Transact-SQL Desk Reference now with O’Reilly online learning.

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