Re: SQL sp

Article View: ee.prog

Article #116

#116

From: Asko Seeba
Date: Fri, 07 Mar 2003 11:59

38 lines
2300 bytes

Ma k�ll ei m�leta MS SQL stored procedure'i s�ntaksi enam t�pselt, aga 
kas int-t��pi argumendi kaudu intide massiivi edasi andmine k�ibki nii 
lihtsalt? Kui ma usuks/arvaks, et nii saab, siis debugimiseks ma vaataks 
hakatuseks, mis siis saab, kui nii kirjutada:

CREATE PROCEDURE spSt
	@katID int,
	@kp smalldatetime
AS
	SELECT @katID
GO

noel wrote:
> 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: <3E6889AC.6020309@spamm.is.forbidden.cyber.ee>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!snoopy.risq.qc.ca!newsfeed.gamma.ru!Gamma.RU!news1.spb.su!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.ut.ee!not-for-mail

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:00:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!snoopy.risq.qc.ca!newsfeed.gamma.ru!Gamma.RU!news1.spb.su!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.ut.ee!not-for-mail
From: Asko Seeba <asko@spamm.is.forbidden.cyber.ee>
Newsgroups: ee.prog,ee.arvutid.www
Subject: Re: SQL sp
Date: Fri, 07 Mar 2003 13:59:40 +0200
Lines: 39
Distribution: Estonia
Message-ID: <3E6889AC.6020309@spamm.is.forbidden.cyber.ee>
References: <3e688729$0$154$bb624dac@diablo.uninet.ee>
NNTP-Posting-Host: tartu.cyber.ee
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: kadri.ut.ee 1047038356 7895 193.40.6.68 (7 Mar 2003 11:59:16 GMT)
X-Complaints-To: usenet@kadri.ut.ee
NNTP-Posting-Date: Fri, 7 Mar 2003 11:59:16 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en

Reply to Parent Message