SELECT * FROM XMLParser ( ON input_table Text_Column ('text_column') Nodes ('node_pair_string[,...]') [ Sibling ('sibling_node_string[,...]') ] [ Delimiter ('delimiter') ] [ SiblingDelimiter ('sibling_delimiter') ] [ MaxItemNum ('max_item_number') ] [ Ancestor ('nodes_path' [,...]) ] [ OutputColumnNodeID ('output_column_node') ] [ OutputColumnParentNodeName ('output_column_parent_node') ] [ OutputColumnGrandparentNode_Name ('output_column_grandparent_node') ] [ ErrorHandler ('{'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'} [;[output_column:] column[,...]]') ] [ Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,...]')] );