Re: SQL sp

Article View: ee.prog

Article #120

#120

From: Ats Vooglaid
Date: Fri, 07 Mar 2003 16:16

17 lines
1659 bytes

"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: <3e68c5ce$1@news.infonet.ee>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.ut.ee!news.estnet.ee!news.infonet.ee

References: <3e688729$0$154$bb624dac@diablo.uninet.ee> <3e688a34$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-07 08:20:09 PST
From: "Ats Vooglaid" <ats@remove!delfi.ee>
Newsgroups: ee.prog,ee.arvutid.www
References: <3e688729$0$154$bb624dac@diablo.uninet.ee> <3e688a34$1@news.infonet.ee>
Subject: Re: SQL sp
Date: Fri, 7 Mar 2003 18:16:14 +0200
Lines: 19
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: host62.artecdesign.ee
Message-ID: <3e68c5ce$1@news.infonet.ee>
X-Trace: news.infonet.ee 1047053774 host62.artecdesign.ee (7 Mar 2003 18:16:14 +0200)
Organization: INFONET.EE
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!uio.no!newsfeed1.funet.fi!newsfeeds.funet.fi!newsfeed.uninet.ee!news.ut.ee!news.estnet.ee!news.infonet.ee

Reply to Parent Message