/* ------------------------ My Meta Content Here SEO ------------------------ */

Pages

Main Menu




Wednesday, May 21, 2014

Some important user defined function in sql server

Creating user defined function for splitting string values with comma separated

CREATE FUNCTION [fn_SplitComma](@String varchar(8000), @Delimiter char(1))
returns @temptable TABLE (items varchar(8000))
as
begin
        declare @idx int
        declare @slice varchar(8000)
    

        select @idx = 1
                if len(@String)<1 font="" is="" nbsp="" null="" or="" return="" tring="">
    

        while @idx!= 0
        begin
                set @idx = charindex(@Delimiter,@String)
                if @idx!=0
                        set @slice = left(@String,@idx - 1)
                else
                        set @slice = @String
                

                if(len(@slice)>0)
                        insert into @temptable(Items) values(@slice)


                set @String = right(@String,len(@String) - @idx)
                if len(@String) = 0 break
        end
return
end
_________________________________________________________________________________

No comments:

Post a Comment

Recent Posts

My Blog List