🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #9781

sql server֧��with��䴴���ֲ���ʱ��ͼ��

#9781
From: ��
Date: Thu, 10 Jul 2003 04:08
12 lines
1185 bytes
��������������
  with tempview(atrib1,attrib2,attrib3) as
       select atrib1,attrib2,attrib3
        from table
  select *
        from tempview

--
http://bbs.sjtu.edu.cn/showfile?name=guanshuidexiachang.gif 

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM:���С��]
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.80.44.149]
Technical Details
Message-ID: <47Ckhj$bqb@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!news.neu.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,f69a49ad14af1b59,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-07-09 21:08:59 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!news.neu.edu.cn!SJTU
From: looker.bbs@bbs.sjtu.edu.cn (��)
Newsgroups: cn.bbs.comp.database
Subject: sql server֧��with��䴴���ֲ���ʱ��ͼ��
Date: 10 Jul 2003 04:08:12 GMT
Organization: ��ˮ˼Դ
Message-ID: <47Ckhj$bqb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1057809981.A
Lines: 12