用SQL看博客、新闻

最新推荐文章于 2024-10-19 14:58:23 发布

sqlhub

最新推荐文章于 2024-10-19 14:58:23 发布

阅读量777

点赞数

文章标签： sql schema table path file xml

本文链接：https://blog.csdn.net/sqlhub/article/details/1153715

版权

SQLHUB发布1.060901版本，全面支持RSS阅读，可以看博客，看新闻

http://www.hgsql.com

下面是创建CSDN博客的SQL语句：

create schema csdnblog type xml path 'http://blog.csdn.net/';
select execute('create table CSDNBLOG.' + f2 + ' file ''' + f1 + '/Rss.aspx'' row_xpath ''rss/channel/item'' (
       TITLE VARCHAR format ELEMENT element ''title'',
       LINK VARCHAR format ELEMENT element ''link'',
       DESCRIPTION VARCHAR format ELEMENT element ''description'',
       PUBDATE VARCHAR format ELEMENT element ''pubDate'',
       )')
from rowset(row('fuchunyi','傅纯一'),
             row('gvanrossum','GuidovanRossum'),
             row('yuanmeng001','袁萌'),
             row('zhangxiaoxiang','张孝祥'),
             row('caterpillar_here','林信良'),
             row('Byron_hu','胡百敬'),
             row('jiangtao','蒋涛'),
             row('grhunter','韩磊'),
             row('myan','孟岩'),
             row('superyan','闫辉'),
             row('zdg','曾登高'),
             row('gigix','熊节'),
             row('xiaosun','孙向晖'),
             row('jiangsheng','蒋晟'),
             row('qingrun','青润'),
             row('calvinxiu','江南'),
             row('nuke','夏昕'),
             row('wangyonggang','王咏刚'),
             row('sunhui','孙辉'),
             row('iright','朱伟杰'),
             row('zhanghongju','张洪举'),
             row('pongba','刘未鹏'),
             row('fjxufeng','徐锋'),
             row('panaimin','潘爱民'),
             row('mfowler','MartinFowler'),
             row('zjcxc','邹建'),
             row('jaminwm','徐建明'),
             row('hongbo781202','杨洪波'),
             row('KerryZhu','朱少民'),
             row('FantasiaX','刘铁猛'),
             row('fannyfish','任晓宇'),
             row('chenshaoying','陈绍英'),
             row('yeka','周筠'),
             row('limingch','章立民'),
             row('gordonliwei','刘新军'),
             row('giltworld','崔启亮'),
             row('stanleycheung','张昊'),
             row('hsutter','HerbSutter'),
             row('pjeby','PhillipJ.Eby'),
             row('solstice','陈硕'),
             row('kongdong','林金海'),
             row('chrischengzh','程朝晖'),
             row('zhaoke','赵珂'),
             row('jakarta99','李日贵'),
             row('grantji','吉晓峰'),
             row('paulex','杨普'),
             row('knlgetter','刘昀'),
             row('GoldenNing','宁德军'),
             row('DanielQChen','DanielQChen'),
             row('Cavien','肖菁'),
             row('kingofark','方舟'),
             row('hbyufan','孙鑫'),
             row('james999','胡长城'),
             row('oiio','郭安定'),
             row('rmartin','RobertCMartin'),
             row('accesine960','田春峰'),
             row('microrain','辛佳雨'),
             row('dotnetcool','奚江华'),
             row('cll0320','陈亮亮'),
             row('EricLee00','李宁'),
             row('net_lover','孟宪会'),
             row('cunruizhai','寸锐斋'),
             row('absurd','absurd'),
             row('stanleycheung','张昊'),
             row('battle_cry','崔秉正'),
             row('it_hefa','何砝'),
             row('aawolf','马宁'),
             row('danny_xcz','纯月'),
             row('simondale','SimonDale'),
             row('Juishl','芮祥麟'),
             row('xiazhang','张侠'),
             row('ericnewcomer','EricNewcomer'),
             row('beckel','BruceEckel'),
             row('code6421','黄忠成'));