本文共 651 字,大约阅读时间需要 2 分钟。
/*Description : 将字符串按指定字符分隔后存储到tableSELECT * FROM dbo.[SplitToTable_BySpecifySymbol]('abcd,edfadk,kjlfkj',',')*/CREATE FUNCTION [dbo].[SplitToTable_BySpecifySymbol]( @InputString nvarchar(MAX), @Symbol varchar(1))RETURNS@tblReturn TABLE (COL1 nvarchar(60))ASBEGINDECLARE @CIndex smallintWHILE (@InputString<>'' and @Symbol <>'')BEGINSET @CIndex=CHARINDEX(@Symbol,@InputString)IF @CIndex=0 SET @CIndex=LEN(@InputString)+1 --透過substring函數取得第一個字串,並輸入資料表變數中INSERT INTO @tblReturn (COL1)VALUES (SUBSTRING(@InputString,1,@CIndex-1))IF @CIndex=LEN(@InputString)+1 BREAKSET @InputString=SUBSTRING(@InputString,@CIndex+1,LEN(@InputString)-@CIndex)ENDRETURNEND
转载地址:http://wpmdi.baihongyu.com/