Tag: string split

  • The fastest way to split a string using CLR

    The original post appeared here: http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx Please visit the original website for more discussion, this is for reference purpose only.   using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction( FillRowMethodName = “FillRow_Multi”, TableDefinition = “item nvarchar(4000)” ) ] public static IEnumerator SplitString_Multi( [SqlFacet(MaxSize = -1)]…