工作需要筆記

CREATEFUNCTION dbo.splitstring (@stringToSplit VARCHAR(MAX))
RETURNS
 @returnList TABLE([Name][nvarchar](500))ASBEGINDECLARE@name NVARCHAR(255)DECLARE@pos INT

 WHILE CHARINDEX(',',@stringToSplit)>0BEGINSELECT@pos  = CHARINDEX(',',@stringToSplit)SELECT@name = SUBSTRING(@stringToSplit,1,@pos-1)INSERTINTO@returnList 
  SELECT@name

  SELECT@stringToSplit = SUBSTRING(@stringToSplit,@pos+1, LEN(@stringToSplit)-@pos)ENDINSERTINTO@returnList
 SELECT@stringToSplit

 RETURNEND

SELECT*FROM dbo.splitstring('91,12,65,78,56,789')