摘要:
/****** Description: select * from dbo.Split('100,200 300;400',', ;') return value is 4 rows table with values 100,200,300,400. ******/CREATE FUNCTION [dbo].[Split] ( @str AS NVARCHAR(1000) , @delimiters AS NVARCHAR(100) )RETURNS @t TABLE ( pos INT NOT NULL , value NVARCHAR(100) NOT NULL ) 阅读全文