Where @RunAt = 1 i SP ???

Article View: dk.edb.database

Article #15201

#15201

From: stk
Date: Mon, 09 Jul 2001 09:48

29 lines
1332 bytes

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?

Stefan






-- 
Leveret af:
http://www.kandu.dk/
"Vejen til en hurtig l�sning"

Technical Details

Message-ID: <f5f27.1105$6x5.146210@news000.worldonline.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,f7792a7fe2136aae,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-09 02:47:56 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
From: "stk" <stk.news@kandu.dk>
Newsgroups: dk.edb.database
Subject: Where @RunAt = 1 i SP ???
Lines: 30
Organization: www.kandu.dk supporting usenet (1 678)
Message-ID: <f5f27.1105$6x5.146210@news000.worldonline.dk>
Date: Mon, 09 Jul 2001 09:48:47 GMT
NNTP-Posting-Host: 213.237.17.223
X-Complaints-To: news-abuse@wol.dk
X-Trace: news000.worldonline.dk 994672075 213.237.17.223 (Mon, 09 Jul 2001 11:47:55 MET DST)
NNTP-Posting-Date: Mon, 09 Jul 2001 11:47:55 MET DST