Blog Archives

Split string in Sql Server

Today I found very good solution, to split the string in Sql Server: //Sql Function CREATE FUNCTION [dbo].[Split] ( @String NVARCHAR(4000), @Delimiter NCHAR(1) ) RETURNS TABLE AS RETURN ( WITH Split(stpos,endpos) AS( SELECT 0 AS stpos, CHARINDEX(@Delimiter,@String) AS endpos UNION

Tagged with:
Posted in SQL Server

CLR stored procedures

Introduction CLR Integration Code that runs within the CLR is referred to as managed code. The CLR provides various functions and services required for program execution, including just-in-time (JIT) compilation, allocating and managing memory, enforcing type safety, exception handling, thread

Posted in .Net, Asp.Net, C#, CLR, email, gmail, SQL Server, vb.net
Top Rated

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

Blog Stats
  • 29,684 hits