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:
Post Comments (Atom)
test smtp server with powershell
Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...
-
Here is instruction how to make blinking text in rainmeter: 1.right click and select " Edit skin " 2.add following code to temp...
-
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring...
-
If you use Visual Studio to open a Web project that was developed for the .NET Framework 2.0, the .NET Framework 3.0, or the .NET Framework...
No comments:
Post a Comment