SQL Query XML column. 　　SQL　查询　ｘｍｌ　字段

时间：2011-05-19 来源：zencorn

１

select Data from sct_DataSourceDatasetRecord where (DataSourceDatasetID = '117' or DataSourceDatasetID = '118' ) SELECT  DataSourceDatasetRecordID, Data.query('//Investment') as InvesValue from sct_DataSourceDatasetRecord where (DataSourceDatasetID = '117'or DataSourceDatasetID = '118')

SELECT  DataSourceDatasetRecordID, Data.query('data(//Investment)') as InvesValue from sct_DataSourceDatasetRecord where (DataSourceDatasetID = '117'or DataSourceDatasetID = '118')

select DataSourceDatasetRecordID , InvesValue  from
(SELECT  DataSourceDatasetRecordID, Data.query('data(//Investment)') as InvesValue from sct_DataSourceDatasetRecord where (DataSourceDatasetID = '117'or DataSourceDatasetID = '118')) as result
where Cast(InvesValue as varchar )= 'c1'

２．　SQL query result.

相关阅读更多 +