Chapter 10. Programming Structures in SQL

IN THIS CHAPTER

A language isn't a programming language until it encompasses the basic fundamentals of logical operations. These operations include the mundane testing functions such as equal (=), less than (<), and greater than (>) and more complex operations such as looping and jumping. This makes T-SQL a programming language. Admittedly, T-SQL is nowhere near as powerful as some of its cousins such as C++, Visual Basic, or even COBOL. Another requirement for a programming language is the ability to call, create, and use functions. With SQL Server, you can use a number of built-in functions as well as create stored procedures ...

Get Writing Stored Procedures for Microsoft SQL Server 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.