CHAPTER 13

image

CLR

There are several different programming paradigms that exist nowadays. Some languages, such as SQL or XQuery, are declarative. They define what needs to be done without specifying how it needs to be achieved. Other languages, such as C# or Java, are imperative. This model requires specifying exact step-by-step control flow of the execution, defining how to achieve the results.

As an example, think about a scenario where you need to read all of the data that belongs to a specific customer. In the declarative model implemented in SQL, you would use where clause with the predicate on the CustomerId column. In the imperative model, ...

Get Pro SQL Server Internals 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.