SQL Server 2005 and CLR

Another interesting MSDN article has been published. Using CLR Integration in SQL Server 2005 is a broad (and verbose) description of key aspects of CLR/T-SQL integration. Among the questions answered are:

  • Stored procedures: managed code vs. T-SQL?
  • How do I write stored procedures and functions in C# (or VB or whatever)?
  • How to access and return data to the caller from a CLR SP?
  • What are TVFs (Table valued functions)? (in short: functions that return a table-like stream of data)
  • Writing your user-defined aggregation operators (can you say SELECT THIRD_BIGGEST(Age) FROM Person?)
  • How to use custom-defined types (.net structs/classes) as column types?

Grab a cup of coffee (or whichever poison you prefer) and allocate at least half an hour if you intend to read the article in one go. It's heavy but definitely worth it. Some of the examples – such as the RSS reader implemented as a TVF – sound ridiculous at first, but think about it. All of this is going to change the way we program against databases and design our architectures. The start of the revolution is only a year away.

November 17, 2004 В· Jouni Heikniemi В· One Comment
Posted in: .NET

One Response

  1. Levi Lenn - January 12, 2021

    I together with my guys ended up viewing the nice tips and tricks from your web site and then all of the sudden got a horrible suspicion I never expressed respect to the blog owner for those techniques. My guys happened to be for this reason warmed to see them and have in effect in fact been tapping into these things. We appreciate you getting simply thoughtful as well as for opting for this kind of wonderful subjects most people are really wanting to be informed on. My very own sincere regret for not expressing gratitude to you earlier.

Leave a Reply