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