摘要: MSSQL Split表字段--拆分字符串之后匹配结果集合CREATE FUNCTION [dbo].[fnSplit]( @sInputList VARCHAR(8000) -- List of delimited items , @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items) RETURNS @List TABLE (item VARCHAR(8000))BEGINDECLARE @sItem VARCHAR(8000)WHILE CHARINDEX(@sDelimiter,@sInput 阅读全文
posted @ 2010-12-28 10:11 活雷锋 阅读(1227) 评论(0) 推荐(1) 编辑