Using CLR Integration in SQL Server 2005

There's alot to look forward to in SQL Server 2005, and one of the big improvements that can't be overlooked is the integration of the .NET CLR, replacing the T-SQL environment. In other words, stored procedures, triggers, and functions can be written in any .NET language, most notably C# and VB.NET, but also including such divergent choices as Perl, Python, and even COBOL. Whatever is your favorite, you can use it to run logic in the database.

Data Access and Storage Developer Center: Using CLR Integration in SQL Server 2005 is an MSDN article that has a rather detailed overview of how to use the CLR. It includes to pretty complete examples, ready to cut and paste as a template, that demonstrate running a production scheduling routine for a manufacturing facility, and of creating a data validation trigger to validate email and phone number columns. Lots of good examples, all with code in C#.