Piccolo aiuto su STORED

Article View: free.it.visual-basic

Article #1657

Back to free.it.visual-basic Previous Next

#1657

From: Gino
Date: Wed, 17 Mar 2004 10:57

26 lines
1837 bytes

PREMETTO che � la mia prima stored e non sono riuscito ancora a capirci
molto:


CREATE PROCEDURE ProvaStored AS
 DECLARE
  @Note  VARCHAR(500),
  @StartFido INT,
  @StartBanca INT,

 SELECT
  an_conto,
  @Note=CONVERT(varchar(500), an_note2)),
  @StartFido=PATINDEX('%FIDO:%',@Note),
  @StartBanca=PATINDEX('%BANCA:%',@Note),
 FROM anagra
 WHERE an_tipo='S'

GO


Come si fa a dichiarare delle variabili all'interno di una SELECT da poter
poi riutilizzare nelle varie clausole WHERE select , ecc ?

Grazie, a chi fa un po' di luce
Ciao

Technical Details

Message-ID: <c39anj$23o$1@grillo.cs.interbusiness.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!zeus.visi.com!priapus.visi.com!orange.octanews.net!news-out.visi.com!petbe.visi.com!news.octanews.net!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,e5db9359cb9fcf27,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2004-03-17 03:03:10 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!zeus.visi.com!priapus.visi.com!orange.octanews.net!news-out.visi.com!petbe.visi.com!news.octanews.net!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news!not-for-mail
From: "Gino" <a_che_te_la_scrivo_la_mia_mail@sei_proprio_convinto.it>
Newsgroups: free.it.visual-basic
Subject: Piccolo aiuto su STORED
Date: Wed, 17 Mar 2004 11:57:38 +0100
Organization: Centro Servizi Interbusiness
Lines: 29
Message-ID: <c39anj$23o$1@grillo.cs.interbusiness.it>
NNTP-Posting-Host: 213.26.161.197
X-Trace: grillo.cs.interbusiness.it 1079520819 2168 213.26.161.197 (17 Mar 2004 10:53:39 GMT)
X-Complaints-To: news@interbusiness.it, abuse@interbusiness.it
NNTP-Posting-Date: Wed, 17 Mar 2004 10:53:39 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165