看看这个动态枢纽，以及最近的这一枢纽-您基本上需要能够
SELECt DISTINCT FieldName使用此技术动态地构建查询。
这是您特定问题的完整答案（请注意，从不同属性生成列表时，如果知道列应显示的顺序，则存在列顺序弱点）：
DECLARE @template AS varchar(MAX)SET @template = 'SELECT FormEntryId ,{@col_list} ,DateCreated FROM FormEntry'DECLARE @col_template AS varchar(MAX)SET @col_template = 'FormXML.value(''/Root[1]/Form[1]/FormData[@FieldName="{FieldName}"][1]/@FieldValue'',''varchar(max)'') AS {FieldName}'DECLARE @col_list AS varchar(MAX);WITH FieldNames AS ( SELECt DISTINCT FieldName FROM FormEntry CROSS APPLY ( SELECt X.FieldName.value('@FieldName', 'varchar(255)') FROM FormXML.nodes('/Root[1]/Form[1]/FormData') AS X(FieldName) ) AS Y (FieldName))SELECt @col_list = COALESCE(@col_list + ',', '') + REPLACE(@col_template, '{FieldName}', FieldName)FROM FieldNamesDECLARE @sql AS varchar(MAX)SET @sql = REPLACE(@template, '{@col_list}', @col_list)EXEC (@sql)
