sqlserver调用qqmap服务,根据地点获取所在城市(三)
, parent_ID, StringValue, ValueType)
SELECT @name, @parent_ID, stringvalue, 'string'
FROM @strings
WHERE string_id=SUBSTRING(@value, 8, 5)
ELSE
IF @value IN ('true', 'false')--a boolean!
INSERT INTO @hierarchy
(NAME, parent_ID, StringValue, ValueType)
SELECT @name, @parent_ID, @value, 'boolean'
ELSE
IF @value='null' --it is a null
INSERT INTO @hierarchy
(NAME, parent_ID, StringValue, ValueType)
SELECT @name, @parent_ID, @value, 'null'
ELSE
IF PATINDEX('%[^0-9]%', @value)>
0 --a real number
INSERT INTO @hierarchy
(NAME, parent_ID, StringValue, ValueType)
SELECT @name, @parent_ID, @value, 'real'
ELSE --it must be an INT
INSERT INTO @hierarchy
(NAME, parent_ID, StringValue, ValueType)
SELECT @name, @parent_ID, @value, 'int'
END
END
--and so lastly we put the root into the hierarchy.
INSERT INTO @hierarchy (NAME, parent_ID, StringValue, Object_ID, ValueType)
SELECT '-', NULL, '', @parent_id-1, @type
--
RETURN
END