字符串示例: user_oid=$124;A1=1;A2=2;branch_no=1400;
/*
创建字段处理函数
*/
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION F_NODE_21(@val varchar(4000))
RETURNS @ctb TABLE([name] varchar(50),[value] varchar(50))
AS
BEGIN
declare @tmpVal varchar(2000)
declare @name varchar(50)
declare @value varchar(50)
while charindex(';',@val)>0
begin
set @val = substring(@val,CHARINDEX(';', @val)+1,2000)--去掉已经计算过的节点
set @tmpVal = substring(@val,0,CHARINDEX(';', @val)) --得到单个节点的数量 A1=X
set @name=substring(@tmpVal,0,CHARINDEX('=', @tmpVal))
set @value=substring(@tmpVal