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

posted @ 2016-07-12 22:38  change_4_now  阅读(88)  评论(0)  编辑  收藏  举报