ALTER FUNCTION dbo.BeSplit ( @re varchar(max), @beg varchar(max), @end varchar(max)) RETURNS varchar(max) WITH EXECUTE AS CALLER AS BEGIN declare @in int = Charindex(@beg,@re) declare @ou int =-1 declare @locid varchar(max) declare @l11 int =LEN(@beg) if @in > 0 set @ou = Charindex(@end,@re,@in) else return null if @ou > 0 set @locid= SUBSTRING ( @re ,@in+@l11 , @ou-(@in+@l11) ) else set @locid= SUBSTRING ( @re ,@in+@l11 , LEN(@re)-(@in+@l11)+1) RETURN @locid END; GO
Wednesday
dbo.BeSplit TSQL function to split by beginning and end string
Subscribe to:
Posts (Atom)
imagemagic add text to image
rem different types of text annotations on existing images rem cyan yellow orange gold rem -gravity SouthWest rem draw text and anno...
-
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring&...
-
Perfect blog post must include following elements (from 1 to 13): 1.Big catchy header in 30px font size 2.First copy of social links and com...
-
SetKeyDelay , 75 , 75 ;Exits AutoHotKey application. $^CapsLock:: ExitApp return ;Pauses AutoHotKey Script. F6:: Pause , Toggle, 1 $x:: ...