O'Reilly logo

Relational Database Programming: A Set-Oriented Approach by Stefan Ardeleanu

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

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

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