将传入存储过程中的字符串截取调用
/****** Object: UserDefinedFunction [dbo].[f_split] Script Date: 04/16/2015 14:35:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create function [dbo].[f_split](@c varchar(max),@split varchar(2)) returns @t table(col varchar(200)) as begin while(charindex(@split,@c)<>0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end insert @t(col) values (@c) return end GO
--调用--select @Sum=SUM(xxxx) from XXX where ID in (select * from f_split(@ID,','))