一条有关字符分割的问题

[@more@]

原来的问题来自CSDN:http://community.csdn.net/Expert/topic/5340/5340668.xml?temp=.4023554

/*
一条有关字符分割的问题
使用例子：
EXECUTE ProcName N'brand are among the most trusted names in business',10
结果:
Result
--------------------------------
brand are
among the
most
trusted
names in
business
*/
CREATE PROCEDURE ProcName
@Input varchar(4000),@Len int
AS
DECLARE
@Index int,
@Result varchar(20)
SET @Result=''
CREATE TABLE #Temp(Result varchar(20) )
WHILE 1=1
BEGIN

SET @Index=CHARINDEX(' ',@Input)
IF (@Index=0)
BEGIN
INSERT INTO #Temp SELECT @Result UNION ALL SELECT @Input
BREAK
END
ELSE
BEGIN
IF LEN(@Result+LEFT(@Input,@Index))>@Len
BEGIN
INSERT INTO #Temp SELECT @Result
SET @Result=''
END
SET @Result=@Result+LEFT(@Input,@Index)
SET @Input=RIGHT(@Input,LEN(@Input)-@Index)
END
END
SELECT * FROM #Temp
DROP TABLE #Temp
GO

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7764484/viewspace-898117/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7764484/viewspace-898117/