Re: SQL sp

Article View: ee.prog

Article #117

#117

From: Urmo
Date: Fri, 07 Mar 2003 12:04

36 lines
2019 bytes

MS SQL ei v�imalda array kasutamist. Tavaliselt lahendatakse see miski
r�veda h�kiga, kus
parameetrid antakse sisse stringina mis procis lahti h�kitakse ja
EXECitakse. Koos k�ige sellega
kaasnevate r��mudega (turva ntx)

"noel" <noel1@mail.ee> wrote in message
news:3e688729$0$154$bb624dac@diablo.uninet.ee...
> 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: <3e688a34$1@news.infonet.ee>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.infonet.ee

References: <3e688729$0$154$bb624dac@diablo.uninet.ee>

Show Full Headers

Complete Article Headers

X-Google-Language: ESTONIAN,CP1257
X-Google-Thread: 115021,d0df9aee1da85cc8
X-Google-Attributes: gid115021,public
X-Google-Thread: f8b3f,d0df9aee1da85cc8
X-Google-Attributes: gidf8b3f,public
X-Google-ArrivalTime: 2003-03-07 04:06:59 PST
From: "Urmo" <urmo@mindspamisbadworks.ee>
Newsgroups: ee.prog,ee.arvutid.www
References: <3e688729$0$154$bb624dac@diablo.uninet.ee>
Subject: Re: SQL sp
Date: Fri, 7 Mar 2003 14:04:18 +0200
Lines: 38
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
NNTP-Posting-Host: mindworks.ee
Message-ID: <3e688a34$1@news.infonet.ee>
X-Trace: news.infonet.ee 1047038516 mindworks.ee (7 Mar 2003 14:01:56 +0200)
Organization: INFONET.EE
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news-FFM2.ecrc.net!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.infonet.ee

Reply to Parent Message