Re: Where @RunAt = 1 i SP ???

Article View: dk.edb.database

Article #15156

#15156

From: Peter Lykkegaard
Date: Wed, 18 Jul 2001 06:45

37 lines
2017 bytes

"stk" <stk.news@kandu.dk> wrote in message
news:f5f27.1105$6x5.146210@news000.worldonline.dk...
> Jeg vil gerne v�lge nogle poster i en tabel (MS-SQL70):
>
> TaskJobs:
> Command   RunAtAdd   RunAtDelete
> Cmd1              1                0
> Cmd2              1                1
>
> Jeg har pr�vet f�lgende:
> CREATE PROCEDURE GetJobs
> @RunAt varchar(20)
> AS
> SELECT Command
> FROM TaskJobs
> WHERE @RunAt = 1
>
> Men det vil den ikke helt v�re med til. Kan det lade sig g�re, eller
> _skal_ jeg bruge en case...when ting?
>
Jeg antager at du vil lave en sp hvor du har en enkelt input parameter

CREATE PROCEDURE GetJobs (
    @RunAt varchar(20)
    )
AS
SELECT Command
FROM TaskJobs
WHERE RunAtAdd = @RunAt

Hvis du vil lave noget where clause p� forskellige felter (RunAtAdd,
RunAtDelete) afh�ngig af @RunAt s� er problemstillingen en anden

Skriv gerne igen hvis min antagelse er forkert ;-)

mvh/Peter Lykkegaard

Technical Details

Message-ID: <Daa57.10$Od.1843@news.get2net.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newsfeed1.telenordia.se!news.algonet.se!algonet!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!news.get2net.dk!not-for-mail

References: <f5f27.1105$6x5.146210@news000.worldonline.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,f7792a7fe2136aae
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-17 23:39:35 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newsfeed1.telenordia.se!news.algonet.se!algonet!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: <f5f27.1105$6x5.146210@news000.worldonline.dk>
Subject: Re: Where @RunAt = 1 i SP ???
Lines: 40
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: <Daa57.10$Od.1843@news.get2net.dk>
Date: Wed, 18 Jul 2001 08:45:36 +0200
NNTP-Posting-Host: 130.227.149.195
X-Complaints-To: abuse@uni2.dk
X-Trace: news.get2net.dk 995438371 130.227.149.195 (Wed, 18 Jul 2001 08:39:31 MET DST)
NNTP-Posting-Date: Wed, 18 Jul 2001 08:39:31 MET DST
Organization: UNI2 Internet Kunde

Reply to Parent Message