摘要:
if object_id('dbo.fn_split')is not null drop function dbo.fn_splitgocreate function dbo.fn_split(@inputstr varchar(8000),@seprator varchar(10))returns @temp table (a varchar(200))asbegindeclare @i intset @inputstr = rtrim(ltrim(@inputstr))set @i = charindex(@seprator, @inputstr)while @i > 阅读全文