摘要:
declare@sqlvarchar(1024)declare@oldhscodepattenvarchar(50)declare@newhscodepattenvarchar(50)declare@corpidpattenvarchar(50)declare@chinesenamepattenvarchar(50)declare@newchinesenamepattenvarchar(50)de...
阅读全文
posted @ 2008-03-13 10:33
nerozhang
阅读(318)
推荐(0)
编辑
摘要:
--按指定符号分割字符串,返回分割后的元素个数createfunctionGet_StrArrayLength(@strvarchar(1024),--分割字符串@splitvarchar(10)--分割符号)returnsintasbegindeclare@locationintdeclare@startintdeclare@lengthintset@str=ltrim(rtrim(@str))...
阅读全文
posted @ 2008-03-13 10:25
nerozhang
阅读(431)
推荐(0)
编辑