© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_14

14. CLR

Dmitri Korotkevitch

(1)Tampa, Florida, USA

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 an 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 the where clause with the predicate on the

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.