摘要:
转载....AndyJanCREATEfunctionGet_StrArrayLength(@strvarchar(1024),--要分割的字符串@splitvarchar(10)--分隔符号)returnsintasbegindeclare@locationintdeclare@startintdeclare@lengthintset@str=ltrim(rtrim(@str))set@location=charindex(@split,@str)set@length=1while@location<>0beginset@start=@location+1set@location 阅读全文