解析xml

解析xml返回为一个表结构

 StringReader stream = new StringReader(sXML);
                        XmlTextReader reader = new XmlTextReader(stream);
                        DataSet xmlDS = new DataSet();
                        xmlDS.ReadXml(reader);
                        DataTable xmlDT   = xmlDS.Tables[4];

获得表名

select   name   from   sysobjects   where   type='u'  
and   name like 'tbmcd_card_origin_%'
go
select   name   from   sysobjects   where   type='u'  
and   name like 'tbmcd_card_data_%' and len(name)=23
go