在sqlserver中创建表值函数

1、创建表值函数SplitStr（用逗号分割字符串）

ALTER FUNCTION [dbo].[SplitStr] 
(@RowData nvarchar(4000), @SplitOn nvarchar(4000)) 
RETURNS @RtnValue TABLE (DATA nvarchar(4000)) 
AS 
BEGIN 
	DECLARE @Cnt int
	SET @Cnt = 1 
	While (Charindex(@SplitOn,@RowData)>0)
		BEGIN
			INSERT INTO @RtnValue (DATA)
			SELECT DATA = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))
			SET @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
			SET @Cnt = @Cnt + 1
		END
	INSERT INTO @RtnValue (DATA)
	SELECT DATA = ltrim(rtrim(@RowData)) 
	RETURN 
END

注：https://www.cnblogs.com/OpenCoder/p/10658742.html

https://www.cnblogs.com/csdbfans/p/3514538.html

2、数据库中有的字段的值为多个值以逗号连接而成

注：根据逗号将字符串分隔

https://blog.csdn.net/sqlserverdiscovery/article/details/79187307