O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

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

Transactions in SQL CLR (CLR Integration)

No chapter on transactions is complete without a discussion of transactions in SQL CLR. Transactions behave so differently with SQL CLR that this topic warrants its own section.

So far, we have discussed local transactions in SQL Server and ADO.NET, as well as distributed transactions in ADO.NET, SQL Server, and the .NET Framework in general. We noted that in PSPE, a distributed transaction might not be distributed. Thus, the boundaries of what is distributed and what is not are already blurry. Well in SQL CLR, they are not only blurry, they are downright indistinct.

In Chapter 3, you learned about the basics of SQL CLR. Here, you will build on the same concepts and write a simple SQL CLR stored procedure ...

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