CREATE FUNCTION [dbo].[split]
(
@SourceSql VARCHAR(MAX),
@StrSeprate VARCHAR(10)
)
RETURNS @temp TABLE(line VARCHAR(MAX))
AS
BEGIN
DECLARE @i INT
SET @SourceSql = rtrim(ltrim(@SourceSql))
SET @i = charindex(@StrSeprate,@SourceSql)
while @i >= 1
BEGIN
IF len(LEFT(@SourceSql,@i-1))>0
BEGIN
INSERT @temp VALUES(LEFT(@SourceSql,@i-1))
END
SET @SourceSql=SUBSTRING(@SourceSql,@i+len(@StrSeprate),len(@SourceSql)-@i)
SET @i=charindex(@StrSeprate,@SourceSql)
END
IF @SourceSql <> ''
INSERT @temp VALUES(@SourceSql)
RETURN
END
//SQL/7373