Today's MSDN Webcast - Stored Procs, Functions, and SQLTypes
So today I was able to advance the .NET CLR conversation, with some additional examples, discuss the differences between a Procedure and a Function, the importance of using SQLTypes, requirements to using a function as an index-able column. Then I touched breifly on Table-Valued Functions (this we will discuss further, later on).
The question and answer period, was once again an excellent experience - great questions (if anyone is leaving early - don't). There were a few questions that I took away for further discussion.
1. Discuss in further details the Nullability of SQL data types
2. How, when and why to use the @@rowcount from within .NET methods
3. How to send an email using databasemail from within a .NET procedure
4. Is it possible to use a config file (e.g. MyAssembly.dll.Config) for the attributes
5. What kind of context is available in the 2 methods necessary for building a Table-Valued Function
I will begin to discuss each one of these here, I look forward to some interesting conversation around these topics.
Here is the link to the sample code from todays webcast (the VB.Net code is included)
http://www.neudesic.com/uploads/Steve_Muise/02_CLRProcs_Demo.zip
See you next week
Steve