xml读取

    select isnull(CamSeqId, ‘‘) as CamSeqId,isnull(cam_config.value(‘(xml/cam/StardardValue)[1]‘,‘int‘),0) as StardardValue,
        isnull(cam_config.value(‘(xml/cam/OpenCacheTime)[1]‘, ‘int‘), 0) as OpenCacheTime,
        isnull(cam_config.value(‘(xml/cam/MinOpenTime)[1]‘, ‘int‘), 0) as MinOpenTime,
        isnull(cam_config.value(‘(xml/cam/CloseCacheTime)[1]‘, ‘int‘), 0) as CloseCacheTime,
        isnull(cam_config.value(‘(xml/cam/IsControlDev)[1]‘, ‘int‘), 0) as IsControlDev from Dat_Camera where camtypeid = 210

xml读取

原文：http://www.cnblogs.com/change4now/p/5665170.html