CLR实用函数：正则、字符串聚合

USE MASTER  

GO  

  

  

--判断手机号是否合法  

SELECT dbo.IS_REGULARMATCH('13888888888','^(1[3,5,8,4][0-9])\d{8}$'),dbo.IS_REGULARMATCH('123456789','^(1[3,5,8,4][0-9])\d{8}$')  

--1 0  

  

--聚合函数使用示例  

IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB  

GO  

CREATE TABLE TB(  

ID INT  

,VAL VARCHAR(MAX)  

)  

GO  

INSERT INTO TB  

SELECT 1,'AA' UNION ALL  

SELECT 2,'B' UNION ALL  

SELECT 3,'CD'  

GO   

INSERT INTO TB  

SELECT 1,'AA' UNION ALL  

SELECT 2,'BB' UNION ALL  

SELECT 3,'CD'  

GO  

SELECT ID,DBO.STR_SUM(VAL),DBO.STR_UNION_SUM(VAL)  

FROM TB  

GROUP BY ID  

/*  

1   AA,AA   AA  

2   BB,B    BB,B  

3   CD,CD   CD  

*/