How to create assembly and functions using CLR
http://towardsnext.wordpress.com/2008/12/12/clr-string-titlecase-function-in-sql-server-2005-clr-integration/ With new feature of CLR integration we can provide function with in our assemblies which can be accessed by the user in the TSQL statements. Let us now try to create one title case function. First create one library project in visual studio 2005. Then create one class with one function inside that. using System; using System.Collections.Generic; using System.Text; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; namespace AssemblyFunctions { public partial class MySQLFunctions { [ SqlFunction (IsDeterministic = true , IsPrecise = true )] public static string TitleCase( string data) { string caseData = data.ToString().Substring(0, 1).ToUpper() + data.ToString().Substring(1, data.ToString().Length -1).ToLower(); return caseData; } } } Now we can compile this assembly and keep it at one location. Then move to MSSQL Management Studio and there in query win...