2024年08月28日 sql server xml example select createdTime,serialNumber,processDefinitionId,processInstanceName,currentState,CAST(fieldValues AS xml ).value('(/TYHR008/txt0101)[1]', 'varchar(20)') AS txt0101,CAST(fieldValues AS xml ).value('(/TYHR008/dlb0102)[1]', &