Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I am inexperienced with cursors and need to use one (I think).
What does this do for me:
select bundle;
from data1;
into cursor 2ft;
where grade = gdValue and siz = szValue and length = 2;
union all;
select bundle;
from data2 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data3 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data4 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data5 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data6 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data7 ;
where grade = gdValue and siz = szValue and length = 2 ;
union all;
select bundle;
from data8 ;
where grade = gdValue and siz = szValue and length = 2
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement