1.5. THE SQL LANGUAGE AND MSS'S TRANSACT-SQL

The Microsoft SQL Server implementation of the SQL language is called Transact-SQL. Programming languages, such as Visual Basic (VB), Pascal, C, and COBOL, are 3GLs (third-generation languages), which means they are procedural. The programmer specifies each step that the program is to take. SQL is a 4GL and is a declarative language (also called a nonprocedural language): The programmer declares what he or she wants, but not how to get it. For example: “List all employee names and telephone numbers from the emps table who were hired on or after 1 January, 2003” would be accomplished by the following SQL (Transact-SQL).

SQL
									SELECT ename, telnum
									FROM emps
									WHERE hiredate >= '1 Jan, 2003';

How to implement ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial