O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 36

Procedural Semi-Procedural and Declarative Programming in SQL

Abstract

A lot of the time, the key to make SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethink in terms of a set-based declarative approach.

Keywords

Procedural programming

Declarative programming

Tibbles

Tables

Files

Rows

Records

Columns

Fields

A lot of the time, the key to make SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem, and rethink in terms of a set-based declarative approach. Joe takes a simple discussion about a problem with a User-Defined Function (UDF) to illustrate the point that ingrained procedural reflexes can often ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required