© Stefan Ardeleanu 2016

Stefan Ardeleanu, Relational Database Programming, 10.1007/978-1-4842-2080-1_7

7. Writing SQL vs. Writing Procedurally

Stefan Ardeleanu

(1)Bucharest, Romania

This chapter offers more examples of the two styles of development. I will use the same simple design taken from an inventory database: two tables that store products and product types. The design of the tables can be seen in Listing 6-7 in Chapter 6. Don’t forget to create the two tables by executing the script in Listing 6-7.

The two styles of development will be illustrated by another opposition, apart from the main one of holistic versus atomic. I am talking about the opposition between SQL code and procedural code. These two approaches are related and similar, but ...

Get Relational Database Programming: A Set-Oriented Approach 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.