RBAR vs. Set based programming for SQL

by

Set-based programming is based upon the mathematical concept of a set, and has operators that work on a whole set at a time. Procedural (RBAR) programming is based more on the traditional computer concepts of files and records. So to increase the salary of all employees in department X by 10%:

Set-based:

UPDATE employees SET salary = salary * 1.10 WHERE department="X";

Procedural (extreme example, pseudo-code):

OPEN cursor FOR SELECT * FROM employees;
LOOP
   FETCH cursor INTO record;
   EXIT WHEN (no more records to fetch);
   IF record.department="X" THEN
      UPDATE employees
      SET    salary = salary * 1.10
      WHERE  employee_id = record.employee_id;
   END IF
END LOOP
CLOSE cursor;

In the procedural version, only one employee row is being updated at a time; in the set-based version, all rows in the “set of employees in department X” are updated at once (as far as we are concerned).

Not sure this adds anything to what you will have already read in your links, but I thought I’d have a shot at it!

More Related Contents:

  1. What is the result of following SQL Query?
  2. sql error, NULL? [closed]
  3. select yesterday date in where condition
  4. What is SQL injection? [duplicate]
  5. Condition within JOIN or WHERE
  6. Index for finding an element in a JSON array
  7. Database design for a survey [closed]
  8. Is there a LastIndexOf in SQL Server?
  9. Get all table names of a particular database by SQL query?
  10. Turn off constraints temporarily (MS SQL)
  11. Sub queries in check constraint
  12. Case in Select Statement
  13. How to use BOOLEAN type in SELECT statement
  14. Remove duplicates using only a MySQL query?
  15. Months between two dates
  16. How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?
  17. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  18. How to find third or nᵗʰ maximum salary from salary table?
  19. sql group by only rows which are in sequence
  20. Does UNION ALL guarantee the order of the result set [duplicate]
  21. Generating random strings with T-SQL
  22. How to select records without duplicate on just one field in SQL?
  23. How to find sum of multiple columns in a table in SQL Server 2005?
  24. Compare Strings ignoring accents in SQL (ORACLE)
  25. SELECT max(x) is returning null; how can I make it return 0?
  26. How to return default value from SQL query
  27. Is this a good way to model address information in a relational database?
  28. Conditional aggregation performance
  29. Retrieve Oracle last inserted IDENTITY
  30. RegEx to Detect SQL Injection

Leave a Comment