Article View: dk.edb.database
Article #15268Re: [MSSQL]sp_columns
From: Bo Larsson
Date: Wed, 06 Jun 2001 15:36
Date: Wed, 06 Jun 2001 15:36
19 lines
1558 bytes
1558 bytes
On Tue, 5 Jun 2001 00:08:23 +0200, "Jakob Andersen"
<jakob@andersen.as> wrote:
>N�r jeg bruger sp_solumns kan jeg s� ikke specifere hvilke resultater jeg
>vil tr�kke ud.. F.eks. �nsker jeg kun TYPE_NAME og COLUMN_NAME. Hvordan kan
>jeg klare det?
Du kan fx g� direkte p� systemtabellerne:
select c.name as COLUMN_NAME, t.name as TYPE_NAME
from syscolumns c
inner join systables t
on c.xtype = t.xtype
where c.id = object_id('tablename')
order by c.colid
--
Bo Larsson
Technical Details
Message-ID:
<3b224d99.756113864@news.inet.tele.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip116.boanxr10.ras.tele.dk!not-for-mailReferences:
<9fh1a7$273$1@sunsite.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,ab8228200da4936 X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-06-06 08:36:37 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip116.boanxr10.ras.tele.dk!not-for-mail From: Bo Larsson <bo.larsson@postkasse.com> Newsgroups: dk.edb.database Subject: Re: [MSSQL]sp_columns Date: Wed, 06 Jun 2001 17:36:23 +0200 Organization: Posted through some European Outpost of TDC Internet A/S Lines: 19 Message-ID: <3b224d99.756113864@news.inet.tele.dk> References: <9fh1a7$273$1@sunsite.dk> Reply-To: please don't NNTP-Posting-Host: ip116.boanxr10.ras.tele.dk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.inet.tele.dk 991841783 22057 195.249.230.244 X-Complaints-To: the appropriate department of the poster's provider X-Newsreader: Forte Agent 1.8/32.548