Re: SQL sp

Article View: ee.prog

Article #121

#121

From: Urmo
Date: Tue, 11 Mar 2003 09:38

24 lines
1936 bytes

Kui ma �igesti m�letan, et saanud tabelit protseduuri parameetriks anda. Mis
oli algne �lesanne.

"Ats Vooglaid" <ats@remove!delfi.ee> wrote in message
news:3e68c5ce$1@news.infonet.ee...
> "Urmo" <urmo@mindspamisbadworks.ee> wrote in message
> news:3e688a34$1@news.infonet.ee...
> > 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)
>
> MS-SQL array on tabel, mis on muutujas:
>
> declare @strarray table(s nvarchar(32))
> insert into @strarray values ('asd')
> insert into @strarray values ('bsd')
> insert into @strarray values ('dsd')
> select * from tabel where otsitav in (select s from @strarray)
>
> Ats
>
>

Technical Details

Message-ID: <3e6dae18$1@news.infonet.ee>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!upp1.onvoy!msc1.onvoy!onvoy.com!news.tele.dk!news.tele.dk!small.news.tele.dk!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.infonet.ee

References: <3e688729$0$154$bb624dac@diablo.uninet.ee> <3e688a34$1@news.infonet.ee> <3e68c5ce$1@news.infonet.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-11 01:40:36 PST
From: "Urmo" <urmo@mindspamisbadworks.ee>
Newsgroups: ee.prog,ee.arvutid.www
References: <3e688729$0$154$bb624dac@diablo.uninet.ee> <3e688a34$1@news.infonet.ee> <3e68c5ce$1@news.infonet.ee>
Subject: Re: SQL sp
Date: Tue, 11 Mar 2003 11:38:45 +0200
Lines: 26
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: <3e6dae18$1@news.infonet.ee>
X-Trace: news.infonet.ee 1047375384 mindworks.ee (11 Mar 2003 11:36:24 +0200)
Organization: INFONET.EE
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!upp1.onvoy!msc1.onvoy!onvoy.com!news.tele.dk!news.tele.dk!small.news.tele.dk!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.infonet.ee

Reply to Parent Message