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.
相关阅读 更多 +
排行榜 更多 +
