Le saint du jour

**sailor lvcv** · 13/09/2007, 09h22

Salut,

Je cherche à savoir s'il existe quelque chose en PB(10) ou en Sybase SQL qui donne le Saint du jour (aujourd'hui St Aimé).
J'ai une application RH, où ils veulent pouvoir voir ça. C'est du gadget, je sais mais leur ancienne appli le faisait du coup y'a défi ^_^

Je travaille avec Powerlib, au cas où.
Merci bien

**sailor lvcv** · 13/09/2007, 17h16

Je vous mets un petit script que je me suis fait aujourd'hui :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
/*==============================================================*/
/* CREATE Table : saint                                         */
/*==============================================================*/
if exists (select 1
            from  sysobjects
            where  id = object_id('saint')
            and    type = 'U')
   drop table saint
go


create table saint (
     jour                 integer                        not null,
     mois                 integer                        not null,
     fete                 varchar(70)                    null,
     constraint PK_SAINT primary key (jour, mois)
)
go

grant SELECT,INSERT,DELETE,UPDATE on saint to ??
go


/*==============================================================*/
/* Contenu de la table : saint                                  */
/*==============================================================*/
INSERT INTO saint VALUES (1, 1, "Jour de l'An")
INSERT INTO saint VALUES (2, 1, "Saint Basile")
INSERT INTO saint VALUES (3, 1, "Sainte Geneviève")
INSERT INTO saint VALUES (4, 1, "Saint Odilon")
INSERT INTO saint VALUES (5, 1, "Saint Edouard")
INSERT INTO saint VALUES (6, 1, "Saint André")
INSERT INTO saint VALUES (7, 1, "Saint Raymond")
INSERT INTO saint VALUES (8, 1, "Saint Lucien")
INSERT INTO saint VALUES (9, 1, "Sainte Alix")
INSERT INTO saint VALUES (10, 1, "Saint Guillaume")
INSERT INTO saint VALUES (11, 1, "Saint Paulin")
INSERT INTO saint VALUES (12, 1, "Sainte Tatiana")
INSERT INTO saint VALUES (13, 1, "Sainte Yvette")
INSERT INTO saint VALUES (14, 1, "Sainte Nina")
INSERT INTO saint VALUES (15, 1, "Saint Rémi")
INSERT INTO saint VALUES (16, 1, "Saint Marcel")
INSERT INTO saint VALUES (17, 1, "Sainte Roseline")
INSERT INTO saint VALUES (18, 1, "Sainte Prisca")
INSERT INTO saint VALUES (19, 1, "Saint Marius")
INSERT INTO saint VALUES (20, 1, "Saint Sébastien")
INSERT INTO saint VALUES (21, 1, "Sainte Agnès")
INSERT INTO saint VALUES (22, 1, "Saint Vincent")
INSERT INTO saint VALUES (23, 1, "Saint Barnard")
INSERT INTO saint VALUES (24, 1, "Saint François")
INSERT INTO saint VALUES (25, 1, "Saint Paul")
INSERT INTO saint VALUES (26, 1, "Sainte Paule")
INSERT INTO saint VALUES (27, 1, "Sainte Angèle")
INSERT INTO saint VALUES (28, 1, "Saint Thomas")
INSERT INTO saint VALUES (29, 1, "Saint Gildas")
INSERT INTO saint VALUES (30, 1, "Sainte Martine")
INSERT INTO saint VALUES (31, 1, "Sainte Marcelle")
INSERT INTO saint VALUES (1, 2, "Sainte Ella")
INSERT INTO saint VALUES (2, 2, "Saint Théophane")
INSERT INTO saint VALUES (3, 2, "Saint Blaise")
INSERT INTO saint VALUES (4, 2, "Sainte Véronique, Vanessa") /* Bah oui faut pas m'oublier !!!*/
INSERT INTO saint VALUES (5, 2, "Sainte Agathe")
INSERT INTO saint VALUES (6, 2, "Saint Gaston")
INSERT INTO saint VALUES (7, 2, "Sainte Eugénie")
INSERT INTO saint VALUES (8, 2, "Sainte Jacqueline")
INSERT INTO saint VALUES (9, 2, "Sainte Apolline")
INSERT INTO saint VALUES (10, 2, "Saint Arnaud")
INSERT INTO saint VALUES (11, 2, "Saint Séverin")
INSERT INTO saint VALUES (12, 2, "Saint Félix")
INSERT INTO saint VALUES (13, 2, "Sainte Béatrice")
INSERT INTO saint VALUES (14, 2, "Saint Valentin")
INSERT INTO saint VALUES (15, 2, "Saint Claude")
INSERT INTO saint VALUES (16, 2, "Sainte Julienne")
INSERT INTO saint VALUES (17, 2, "Saint Alexis")
INSERT INTO saint VALUES (18, 2, "Sainte Bernadette")
INSERT INTO saint VALUES (19, 2, "Saint Gabin")
INSERT INTO saint VALUES (20, 2, "Sainte Aimée")
INSERT INTO saint VALUES (21, 2, "Saint Damien")
INSERT INTO saint VALUES (22, 2, "Sainte Isabelle")
INSERT INTO saint VALUES (23, 2, "Saint Lazare")
INSERT INTO saint VALUES (24, 2, "Saint Modeste")
INSERT INTO saint VALUES (25, 2, "Saint Roméo")
INSERT INTO saint VALUES (26, 2, "Saint Nestor")
INSERT INTO saint VALUES (27, 2, "Sainte Honorine")
INSERT INTO saint VALUES (28, 2, "Saint Romain")
INSERT INTO saint VALUES (29, 2, "Saint Auguste")
INSERT INTO saint VALUES (1, 3, "Saint Aubin")
INSERT INTO saint VALUES (2, 3, "Saint Charles")
INSERT INTO saint VALUES (3, 3, "Saint Gwenolé")
INSERT INTO saint VALUES (4, 3, "Saint Casimir")
INSERT INTO saint VALUES (5, 3, "Saint Olive")
INSERT INTO saint VALUES (6, 3, "Sainte Colette")
INSERT INTO saint VALUES (7, 3, "Sainte Félicité")
INSERT INTO saint VALUES (8, 3, "Saint Jean")
INSERT INTO saint VALUES (9, 3, "Sainte Françoise")
INSERT INTO saint VALUES (10, 3, "Saint Vivien")
INSERT INTO saint VALUES (11, 3, "Sainte Rosine")
INSERT INTO saint VALUES (12, 3, "Sainte Justine")
INSERT INTO saint VALUES (13, 3, "Saint Rodrigue")
INSERT INTO saint VALUES (14, 3, "Sainte Mathilde")
INSERT INTO saint VALUES (15, 3, "Sainte Louise")
INSERT INTO saint VALUES (16, 3, "Sainte Bénédicte")
INSERT INTO saint VALUES (17, 3, "Saint Patrick")
INSERT INTO saint VALUES (18, 3, "Saint Cyrille")
INSERT INTO saint VALUES (19, 3, "Saint Joseph")
INSERT INTO saint VALUES (20, 3, "Saint Herbert")
INSERT INTO saint VALUES (21, 3, "Sainte Clémence")
INSERT INTO saint VALUES (22, 3, "Sainte Léa")
INSERT INTO saint VALUES (23, 3, "Saint Victorien")
INSERT INTO saint VALUES (24, 3, "Sainte Catherine")
INSERT INTO saint VALUES (25, 3, "Saint Humbert")
INSERT INTO saint VALUES (26, 3, "Sainte Larissa")
INSERT INTO saint VALUES (27, 3, "Saint Habib")
INSERT INTO saint VALUES (28, 3, "Saint Gontran")
INSERT INTO saint VALUES (29, 3, "Sainte Gwladys")
INSERT INTO saint VALUES (30, 3, "Saint Amédée")
INSERT INTO saint VALUES (31, 3, "Saint Benjamin")
INSERT INTO saint VALUES (1, 4, "Saint Hugues")
INSERT INTO saint VALUES (2, 4, "Sainte Sandrine")
INSERT INTO saint VALUES (3, 4, "Saint Richard")
INSERT INTO saint VALUES (4, 4, "Saint Isidore")
INSERT INTO saint VALUES (5, 4, "Sainte Irène")
INSERT INTO saint VALUES (6, 4, "Saint Marcellin")
INSERT INTO saint VALUES (7, 4, "Saint Jean-Baptiste")
INSERT INTO saint VALUES (8, 4, "Sainte Julie")
INSERT INTO saint VALUES (9, 4, "Saint Gautier")
INSERT INTO saint VALUES (10, 4, "Saint Fulbert")
INSERT INTO saint VALUES (11, 4, "Saint Stanislas")
INSERT INTO saint VALUES (12, 4, "Saint Jules 1er")
INSERT INTO saint VALUES (13, 4, "Sainte Ida")
INSERT INTO saint VALUES (14, 4, "Saint Maxime")
INSERT INTO saint VALUES (15, 4, "Saint Paterne")
INSERT INTO saint VALUES (16, 4, "Saint Benoît")
INSERT INTO saint VALUES (17, 4, "Saint Etienne")
INSERT INTO saint VALUES (18, 4, "Saint Parfait")
INSERT INTO saint VALUES (19, 4, "Sainte Emma")
INSERT INTO saint VALUES (20, 4, "Sainte Odette")
INSERT INTO saint VALUES (21, 4, "Saint Anselme")
INSERT INTO saint VALUES (22, 4, "Saint Alexandre")
INSERT INTO saint VALUES (23, 4, "Saint Georges")
INSERT INTO saint VALUES (24, 4, "Saint Fidèle")
INSERT INTO saint VALUES (25, 4, "Saint Marc")
INSERT INTO saint VALUES (26, 4, "Sainte Alida")
INSERT INTO saint VALUES (27, 4, "Sainte Zita")
INSERT INTO saint VALUES (28, 4, "Sainte Valérie")
INSERT INTO saint VALUES (29, 4, "Sainte Catherine")
INSERT INTO saint VALUES (30, 4, "Saint Robert")
INSERT INTO saint VALUES (1, 5, "Saint Joseph")
INSERT INTO saint VALUES (2, 5, "Saint Boris")
INSERT INTO saint VALUES (3, 5, "Saint Jacques")
INSERT INTO saint VALUES (4, 5, "Saint Sylvain")
INSERT INTO saint VALUES (5, 5, "Sainte Judith")
INSERT INTO saint VALUES (6, 5, "Sainte Prudence")
INSERT INTO saint VALUES (7, 5, "Sainte Gisèle")
INSERT INTO saint VALUES (8, 5, "Saint Désiré")
INSERT INTO saint VALUES (9, 5, "Sainte Pacôme")
INSERT INTO saint VALUES (10, 5, "Sainte Solange")
INSERT INTO saint VALUES (11, 5, "Sainte Estelle")
INSERT INTO saint VALUES (12, 5, "Saint Achille")
INSERT INTO saint VALUES (13, 5, "Sainte Rolande")
INSERT INTO saint VALUES (14, 5, "Saint Matthias")
INSERT INTO saint VALUES (15, 5, "Sainte Denise")
INSERT INTO saint VALUES (16, 5, "Saint Honoré")
INSERT INTO saint VALUES (17, 5, "Saint Pascal")
INSERT INTO saint VALUES (18, 5, "Saint Eric")
INSERT INTO saint VALUES (19, 5, "Saint Yves")
INSERT INTO saint VALUES (20, 5, "Saint Bernardin")
INSERT INTO saint VALUES (21, 5, "Saint Constantin")
INSERT INTO saint VALUES (22, 5, "Saint Emile")
INSERT INTO saint VALUES (23, 5, "Saint Didier")
INSERT INTO saint VALUES (24, 5, "Saint Donatien")
INSERT INTO saint VALUES (25, 5, "Sainte Sophie")
INSERT INTO saint VALUES (26, 5, "Saint Bérenger")
INSERT INTO saint VALUES (27, 5, "Saint Augustin")
INSERT INTO saint VALUES (28, 5, "Saint Germain")
INSERT INTO saint VALUES (29, 5, "Saint Aymard")
INSERT INTO saint VALUES (30, 5, "Saint Ferdinand")
INSERT INTO saint VALUES (31, 5, "Sainte Perrine")
INSERT INTO saint VALUES (1, 6, "Saint Justin")
INSERT INTO saint VALUES (2, 6, "Sainte Blandine")
INSERT INTO saint VALUES (3, 6, "Saint Charles")
INSERT INTO saint VALUES (4, 6, "Sainte Clotilde")
INSERT INTO saint VALUES (5, 6, "Saint Igor")
INSERT INTO saint VALUES (6, 6, "Saint Norbert")
INSERT INTO saint VALUES (7, 6, "Saint Gilbert")
INSERT INTO saint VALUES (8, 6, "Saint Médard")
INSERT INTO saint VALUES (9, 6, "Sainte Diane")
INSERT INTO saint VALUES (10, 6, "Saint Landry")
INSERT INTO saint VALUES (11, 6, "Saint Barnabé")
INSERT INTO saint VALUES (12, 6, "Saint Guy")
INSERT INTO saint VALUES (13, 6, "Saint Antoine")
INSERT INTO saint VALUES (14, 6, "Saint Elisée")
INSERT INTO saint VALUES (15, 6, "Sainte Germaine")
INSERT INTO saint VALUES (16, 6, "Saint Jean-François")
INSERT INTO saint VALUES (17, 6, "Saint Hervé")
INSERT INTO saint VALUES (18, 6, "Saint Léonce")
INSERT INTO saint VALUES (19, 6, "Saint Romuald")
INSERT INTO saint VALUES (20, 6, "Saint Silvère")
INSERT INTO saint VALUES (21, 6, "Saint Rodolphe")
INSERT INTO saint VALUES (22, 6, "Saint Alban")
INSERT INTO saint VALUES (23, 6, "Sainte Audrey")
INSERT INTO saint VALUES (24, 6, "Saint Jean-Baptiste")
INSERT INTO saint VALUES (25, 6, "Saint Prosper")
INSERT INTO saint VALUES (26, 6, "Saint Anthelme")
INSERT INTO saint VALUES (27, 6, "Saint Fernand")
INSERT INTO saint VALUES (28, 6, "Saint Irénée")
INSERT INTO saint VALUES (29, 6, "Saint Pierre")
INSERT INTO saint VALUES (30, 6, "Saint Martial")
INSERT INTO saint VALUES (1, 7, "Saint Thierry")
INSERT INTO saint VALUES (2, 7, "Saint Martinien")
INSERT INTO saint VALUES (3, 7, "Saint Thomas")
INSERT INTO saint VALUES (4, 7, "Saint Florent")
INSERT INTO saint VALUES (5, 7, "Saint Antoine-Marie")
INSERT INTO saint VALUES (6, 7, "Sainte Marietta")
INSERT INTO saint VALUES (7, 7, "Saint Raoul")
INSERT INTO saint VALUES (8, 7, "Saint Thibaud")
INSERT INTO saint VALUES (9, 7, "Sainte Amandine")
INSERT INTO saint VALUES (10, 7, "Saint Ulric")
INSERT INTO saint VALUES (11, 7, "Saint Benoît")
INSERT INTO saint VALUES (12, 7, "Saint Olivier")
INSERT INTO saint VALUES (13, 7, "Saint Henri")
INSERT INTO saint VALUES (14, 7, "Saint Camille")
INSERT INTO saint VALUES (15, 7, "Saint Donald")
INSERT INTO saint VALUES (16, 7, "Sainte Elvire")
INSERT INTO saint VALUES (17, 7, "Sainte Charlotte")
INSERT INTO saint VALUES (18, 7, "Saint Frédéric")
INSERT INTO saint VALUES (19, 7, "Saint Arsène")
INSERT INTO saint VALUES (20, 7, "Sainte Marina")
INSERT INTO saint VALUES (21, 7, "Saint Victor")
INSERT INTO saint VALUES (22, 7, "Ste Marie-Madeleine")
INSERT INTO saint VALUES (23, 7, "Sainte Brigitte")
INSERT INTO saint VALUES (24, 7, "Sainte Christine")
INSERT INTO saint VALUES (25, 7, "Saint Jacques")
INSERT INTO saint VALUES (26, 7, "Sainte Anne")
INSERT INTO saint VALUES (27, 7, "Sainte Nathalie")
INSERT INTO saint VALUES (28, 7, "Saint Samson")
INSERT INTO saint VALUES (29, 7, "Sainte Marthe")
INSERT INTO saint VALUES (30, 7, "Sainte Juliette")
INSERT INTO saint VALUES (31, 7, "Saint Ignace")
INSERT INTO saint VALUES (1, 8, "St Alphonse-Marie")
INSERT INTO saint VALUES (2, 8, "St Pierre-Julien")
INSERT INTO saint VALUES (3, 8, "Sainte Lydie")
INSERT INTO saint VALUES (4, 8, "Saint Jean-Marie")
INSERT INTO saint VALUES (5, 8, "Saint Abel")
INSERT INTO saint VALUES (6, 8, "Saint Octavien")
INSERT INTO saint VALUES (7, 8, "Saint Gaétan")
INSERT INTO saint VALUES (8, 8, "Saint Dominique")
INSERT INTO saint VALUES (9, 8, "Saint Amour")
INSERT INTO saint VALUES (10, 8, "Saint Laurent")
INSERT INTO saint VALUES (11, 8, "Sainte Claire")
INSERT INTO saint VALUES (12, 8, "Sainte Clarisse")
INSERT INTO saint VALUES (13, 8, "Saint Hippolyte")
INSERT INTO saint VALUES (14, 8, "Saint Evrard")
INSERT INTO saint VALUES (15, 8, "Sainte Marie")
INSERT INTO saint VALUES (16, 8, "Saint Armel")
INSERT INTO saint VALUES (17, 8, "Saint Hyacinthe")
INSERT INTO saint VALUES (18, 8, "Sainte Hélène")
INSERT INTO saint VALUES (19, 8, "Saint Jean-Eudes")
INSERT INTO saint VALUES (20, 8, "Saint Bernard")
INSERT INTO saint VALUES (21, 8, "Saint Christophe")
INSERT INTO saint VALUES (22, 8, "Saint Fabrice")
INSERT INTO saint VALUES (23, 8, "Sainte Rose")
INSERT INTO saint VALUES (24, 8, "Saint Barthélémy")
INSERT INTO saint VALUES (25, 8, "Saint Louis")
INSERT INTO saint VALUES (26, 8, "Sainte Natacha")
INSERT INTO saint VALUES (27, 8, "Sainte Monique")
INSERT INTO saint VALUES (28, 8, "Saint Augustin")
INSERT INTO saint VALUES (29, 8, "Sainte Sabine")
INSERT INTO saint VALUES (30, 8, "Saint Fiacre")
INSERT INTO saint VALUES (31, 8, "Saint Aristide")
INSERT INTO saint VALUES (1, 9, "Saint Gilles")
INSERT INTO saint VALUES (2, 9, "Sainte Ingrid")
INSERT INTO saint VALUES (3, 9, "Saint Grégoire")
INSERT INTO saint VALUES (4, 9, "Sainte Rosalie")
INSERT INTO saint VALUES (5, 9, "Sainte Raïssa")
INSERT INTO saint VALUES (6, 9, "Saint Bertrand")
INSERT INTO saint VALUES (7, 9, "Sainte Reine")
INSERT INTO saint VALUES (8, 9, "Saint Adrien")
INSERT INTO saint VALUES (9, 9, "Saint Alain")
INSERT INTO saint VALUES (10, 9, "Sainte Inès")
INSERT INTO saint VALUES (11, 9, "Saint Adelphe")
INSERT INTO saint VALUES (12, 9, "Saint Apollinaire")
INSERT INTO saint VALUES (13, 9, "Saint Aimé")
INSERT INTO saint VALUES (14, 9, "la Croix Glorieuse")
INSERT INTO saint VALUES (15, 9, "Saint Roland")
INSERT INTO saint VALUES (16, 9, "Sainte Edith")
INSERT INTO saint VALUES (17, 9, "Saint Renaud")
INSERT INTO saint VALUES (18, 9, "Sainte Nadège")
INSERT INTO saint VALUES (19, 9, "Sainte Emilie")
INSERT INTO saint VALUES (20, 9, "Saint Davy")
INSERT INTO saint VALUES (21, 9, "Saint Matthieu")
INSERT INTO saint VALUES (22, 9, "Saint Maurice")
INSERT INTO saint VALUES (23, 9, "Saint Constant")
INSERT INTO saint VALUES (24, 9, "Sainte Thècle")
INSERT INTO saint VALUES (25, 9, "Saint Hermann")
INSERT INTO saint VALUES (26, 9, "Sts Côme et Damien")
INSERT INTO saint VALUES (27, 9, "Saint Vincent")
INSERT INTO saint VALUES (28, 9, "Saint Venceslas")
INSERT INTO saint VALUES (29, 9, "Saint Michel")
INSERT INTO saint VALUES (30, 9, "Saint Jérôme")
INSERT INTO saint VALUES (1, 10, "Sainte Thérèse")
INSERT INTO saint VALUES (2, 10, "Saint Léger")
INSERT INTO saint VALUES (3, 10, "Saint Gérard")
INSERT INTO saint VALUES (4, 10, "Saint François")
INSERT INTO saint VALUES (5, 10, "Sainte Fleur")
INSERT INTO saint VALUES (6, 10, "Saint Bruno")
INSERT INTO saint VALUES (7, 10, "Saint Serge")
INSERT INTO saint VALUES (8, 10, "Sainte Pélagie")
INSERT INTO saint VALUES (9, 10, "Saint Denis")
INSERT INTO saint VALUES (10, 10, "Saint Ghislain")
INSERT INTO saint VALUES (11, 10, "Saint Firmin")
INSERT INTO saint VALUES (12, 10, "Saint Wilfrid")
INSERT INTO saint VALUES (13, 10, "Saint Géraud")
INSERT INTO saint VALUES (14, 10, "Saint Juste")
INSERT INTO saint VALUES (15, 10, "Sainte Thérèse")
INSERT INTO saint VALUES (16, 10, "Sainte Edwige")
INSERT INTO saint VALUES (17, 10, "Saint Baudouin")
INSERT INTO saint VALUES (18, 10, "Saint Luc")
INSERT INTO saint VALUES (19, 10, "Saint René")
INSERT INTO saint VALUES (20, 10, "Sainte Adeline")
INSERT INTO saint VALUES (21, 10, "Sainte Céline")
INSERT INTO saint VALUES (22, 10, "Sainte Elodie")
INSERT INTO saint VALUES (23, 10, "Saint Jean")
INSERT INTO saint VALUES (24, 10, "Saint Florentin")
INSERT INTO saint VALUES (25, 10, "Sainte Doria")
INSERT INTO saint VALUES (26, 10, "Saint Dimitri")
INSERT INTO saint VALUES (27, 10, "Sainte Emeline")
INSERT INTO saint VALUES (28, 10, "Saint Simon")
INSERT INTO saint VALUES (29, 10, "Saint Narcisse")
INSERT INTO saint VALUES (30, 10, "Sainte Bienvenue")
INSERT INTO saint VALUES (31, 10, "Saint Quentin")
INSERT INTO saint VALUES (1, 11, "La Toussaint")
INSERT INTO saint VALUES (2, 11, "Les Défunts")
INSERT INTO saint VALUES (3, 11, "Saint Hubert")
INSERT INTO saint VALUES (4, 11, "Saint Charles")
INSERT INTO saint VALUES (5, 11, "Sainte Sylvie")
INSERT INTO saint VALUES (6, 11, "Sainte Bertille")
INSERT INTO saint VALUES (7, 11, "Sainte Carine")
INSERT INTO saint VALUES (8, 11, "Saint Geoffroy")
INSERT INTO saint VALUES (9, 11, "Saint Théodore")
INSERT INTO saint VALUES (10, 11, "Saint Léon")
INSERT INTO saint VALUES (11, 11, "Saint Martin")
INSERT INTO saint VALUES (12, 11, "Saint Christian")
INSERT INTO saint VALUES (13, 11, "Saint Brice")
INSERT INTO saint VALUES (14, 11, "Saint Sidoine")
INSERT INTO saint VALUES (15, 11, "Saint Albert")
INSERT INTO saint VALUES (16, 11, "Sainte Marguerite")
INSERT INTO saint VALUES (17, 11, "Sainte Elisabeth")
INSERT INTO saint VALUES (18, 11, "Sainte Aude")
INSERT INTO saint VALUES (19, 11, "Saint Tanguy")
INSERT INTO saint VALUES (20, 11, "Saint Edmond")
INSERT INTO saint VALUES (21, 11, "Saint Albert")
INSERT INTO saint VALUES (22, 11, "Sainte Cécile")
INSERT INTO saint VALUES (23, 11, "Saint Clément")
INSERT INTO saint VALUES (24, 11, "Sainte Flora")
INSERT INTO saint VALUES (25, 11, "Sainte Catherine")
INSERT INTO saint VALUES (26, 11, "Sainte Delphine")
INSERT INTO saint VALUES (27, 11, "Saint Séverin")
INSERT INTO saint VALUES (28, 11, "Saint Jacques")
INSERT INTO saint VALUES (29, 11, "Saint Saturnin")
INSERT INTO saint VALUES (30, 11, "Saint André")
INSERT INTO saint VALUES (1, 12, "Sainte Florence")
INSERT INTO saint VALUES (2, 12, "Sainte Viviane")
INSERT INTO saint VALUES (3, 12, "St François-Xavier")
INSERT INTO saint VALUES (4, 12, "Sainte Barbara")
INSERT INTO saint VALUES (5, 12, "Saint Gérald")
INSERT INTO saint VALUES (6, 12, "Saint Nicolas")
INSERT INTO saint VALUES (7, 12, "Saint Ambroise")
INSERT INTO saint VALUES (8, 12, "Sainte Elfie")
INSERT INTO saint VALUES (9, 12, "Saint Pierre")
INSERT INTO saint VALUES (10, 12, "Saint Romaric")
INSERT INTO saint VALUES (11, 12, "Saint Daniel")
INSERT INTO saint VALUES (12, 12, "Ste Jeanne-Françoise")
INSERT INTO saint VALUES (13, 12, "Sainte Lucie")
INSERT INTO saint VALUES (14, 12, "Sainte Odile")
INSERT INTO saint VALUES (15, 12, "Sainte Ninon")
INSERT INTO saint VALUES (16, 12, "Sainte Alice")
INSERT INTO saint VALUES (17, 12, "Saint Gaël")
INSERT INTO saint VALUES (18, 12, "Saint Gatien")
INSERT INTO saint VALUES (19, 12, "Saint Urbain")
INSERT INTO saint VALUES (20, 12, "Saint Théophile")
INSERT INTO saint VALUES (21, 12, "Saint Pierre")
INSERT INTO saint VALUES (22, 12, "Ste Françoise-Xavière")
INSERT INTO saint VALUES (23, 12, "Saint Armand")
INSERT INTO saint VALUES (24, 12, "Sainte Adèle")
INSERT INTO saint VALUES (25, 12, "Jour de Noël")
INSERT INTO saint VALUES (26, 12, "Saint Etienne")
INSERT INTO saint VALUES (27, 12, "Saint Jean")
INSERT INTO saint VALUES (28, 12, "Saints Innocents")
INSERT INTO saint VALUES (29, 12, "Saint David")
INSERT INTO saint VALUES (30, 12, "Saint Roger")
INSERT INTO saint VALUES (31, 12, "Saint Sylvestre")

/*==============================================================*/
/* Procedure stockée : sel_saint                                */
/*==============================================================*/
print    'sel_saint'
SETUSER  'dbo'
go

CREATE PROCEDURE sel_saint AS 
BEGIN 
SELECT fete 
FROM saint 
WHERE jour = DATEPART(dd, GETDATE()) 
AND mois = DATEPART(mm, GETDATE()) 
END   
go

SETUSER
go

grant Execute  on sel_saint to ??
go

J'ai trouvé l'idée et la table chez Holy days PHP
Vous reste plus qu'à faire l'écran et la dw

Le saint du jour

Powerbuilder

Discussions similaires

Partager

Partager