I wrote a class in C# with one method that returns a string. I built the dll and deployed the clr into sql 2005 and everything works just fine.I am now in a situation where I need to use this function in SQL 2000. Is there any way that I can use the existing dll and create a sql 2000 function, and if so how do I go about doing this? If not using the existing dll, how would i go about doing this?Here is the c# code from the deployed dll.using System;using System.Data;using System.Data.SqlClient;using System.Data.SqlTypes;using Microsoft.SqlServer.Server;using System.Text.RegularExpressions;public partial class GECBI{ [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic = true, IsPrecise = true)] public static string RegExMatch(string pattern, string matchString) { Regex r1 = new Regex(pattern); if (r1.Match(matchString.TrimEnd(null)).Success) { Regex testReg = new Regex(pattern); Match regMatch = testReg.Match(matchString); string runnumber = regMatch.ToString(); return runnumber; } else { return null; } }};
porting a clr dll in C# from 2k5 to 2000
Posted - 2006-09-27 : 01:35:01
