随笔分类 -  sql server

sql server中分隔字符的凼数
摘要：CREATE function dbo.split_string(@LongStr varchar(8000),@SearchStr varchar(10))returns @t table(s varchar(100))asbeginwhile (charindex(@SearchStr,@LongStr)>0)begininsert @t select left(@LongStr,cha... 阅读全文
posted @ 2007-03-18 22:48 folen 阅读(304) 评论(0) 推荐(0)