Article View: dk.edb.database
Article #15092Re: MSSQL: R�kkef�lge af felter
From: Peter Lykkegaard
Date: Mon, 25 Jun 2001 14:26
Date: Mon, 25 Jun 2001 14:26
18 lines
1839 bytes
1839 bytes
"James Olsen" <james_olsen@vip.cybercity.dk> wrote in message news:9h78fd$qv1$1@news.cybercity.dk... > > > Men helt generelt s� lad v�re med at bruge select * from ... til andet en > egne ad hoc foresp�rgsler. Det er altid en rigtigt god ide af angive det > explicit ogs� selv om der er tale om 30 kolonner. Men det er bare min > k�phest ;) > Det er faktisk peace of cake Lav en Select * from MyTable Where 1=2 i Query Analyzeren Marker kolonnenavne, og lidt tekst redigering s� har du dine 30/40 whatever feltnavne - endog stavet rigtigt som sidegevinst :-) Evt kan man bruge Access (Access Project), Visual Database Tools, eller Enterprise Manager og bygge select statements visuelt mvh/Peter Lykkegaard
Technical Details
Message-ID:
<nNHZ6.242$nV2.20922@news.get2net.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!news.get2net.dk!not-for-mailReferences:
<fe9be361.0106250040.1baf634f@posting.google.com> <9h78fd$qv1$1@news.cybercity.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,438a9e1049efbeff X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-06-25 07:21:08 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!news.get2net.dk!not-for-mail From: "Peter Lykkegaard" <polonline@hot.mail.com> Newsgroups: dk.edb.database References: <fe9be361.0106250040.1baf634f@posting.google.com> <9h78fd$qv1$1@news.cybercity.dk> Subject: Re: MSSQL: R�kkef�lge af felter Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: <nNHZ6.242$nV2.20922@news.get2net.dk> Date: Mon, 25 Jun 2001 16:26:47 +0200 NNTP-Posting-Host: 130.227.149.195 X-Complaints-To: abuse@uni2.dk X-Trace: news.get2net.dk 993478867 130.227.149.195 (Mon, 25 Jun 2001 16:21:07 MET DST) NNTP-Posting-Date: Mon, 25 Jun 2001 16:21:07 MET DST Organization: UNI2 Internet Kunde