O'Reilly logo

Pro SQL Server Internals by Dmitri Korotkevitch

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

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

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