Article View: ee.prog
Article #115SQL sp
From: noel
Date: Fri, 07 Mar 2003 11:48
Date: Fri, 07 Mar 2003 11:48
22 lines
1579 bytes
1579 bytes
Oleks siis abi veits vaja. Omal pea enam ei taba pointi.
Asi nimelt selline:
on array ntx: 15,16,17
ning see on vaja edastada sp(storedProcedure)-le ning seal kasutan WHERE bla
IN (@strArray)
vastust aga ei saa.
Kus jama seda ei saa aru. Kuup�evaga on k�ik jonksus ning ka �ksiku int-iga.
SQL Server 2000 + ASP 3.0
sp:
CREATE PROCEDURE spSt
@katID int,
@kp smalldatetime
AS
SELECT CategoryID, fromdate
FROM Table
WHERE fromdate = @kp AND CategoryID IN(@katID)
GO
lehel:
cmd.Parameters.Append cmd.CreateParameter("katID", adInteger, adParamInput,
4, intKatID)
Technical Details
Message-ID:
<3e688729$0$154$bb624dac@diablo.uninet.ee>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!diablo.uninet.ee!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ESTONIAN,CP1257 X-Google-Thread: 115021,d0df9aee1da85cc8,start X-Google-Attributes: gid115021,public X-Google-Thread: f8b3f,d0df9aee1da85cc8,start X-Google-Attributes: gidf8b3f,public X-Google-ArrivalTime: 2003-03-07 03:52:07 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!diablo.uninet.ee!not-for-mail From: "noel" <noel1@mail.ee> Newsgroups: ee.prog,ee.arvutid.www Subject: SQL sp Date: Fri, 7 Mar 2003 13:48:49 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Lines: 25 Message-ID: <3e688729$0$154$bb624dac@diablo.uninet.ee> NNTP-Posting-Host: 194.204.62.12 X-Trace: 1047037737 diablo.uninet.ee 154 194.204.62.12