sql 截取 host 函数
来源：互联网 发布：算法导论 第三版百度云 编辑：程序博客网 时间：2024/05/18 16:18
USE [UILogDB]GO/****** Object: UserDefinedFunction [dbo].[Sub_UrlHost] Script Date: 11/09/2011 09:25:02 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:<jianxiong>-- Create date: <Create Date, ,>-- Description:<Description, ,>-- =============================================ALTER FUNCTION [dbo].[Sub_UrlHost] (@Url varchar(300))RETURNS varchar(300)ASBEGINif (CHARINDEX('/',@Url,8)=0)return @Urlreturn (replace(replace(SUBSTRING(@Url,1,CHARINDEX('/',@Url,8)),'http://',''),'/',''))END
