ARI/sql_editors.sql at main · tansuozcelebi/ARI · GitHub

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

/*------ 22.04.2004 10:16:51 --------*/

select
A.AVANSLAR_EKIPKOD,
A.AVANSLAR_KOD,
A.AVANSLAR_MIKTAR,
A.AVANSLAR_MUSTERIKOD,
A.AVANSLAR_TARIH,
E.EKIPAD,
M.MUSTERI_AD
from AVANSLAR A
JOIN EKIP E
ON E.EKIPKODU=A.AVANSLAR_EKIPKOD
JOIN MUSTERI M
ON M.MUSTERI_KOD = A.AVANSLAR_MUSTERIKOD

/*------ 22.04.2004 10:17:14 --------*/

select
A.AVANSLAR_EKIPKOD,
A.AVANSLAR_KOD,
A.AVANSLAR_MIKTAR,
A.AVANSLAR_MUSTERIKOD,
A.AVANSLAR_TARIH,
E.EKIPAD,
M.MUSTERI_AD
from AVANSLAR A
LEFT JOIN EKIP E
ON E.EKIPKODU=A.AVANSLAR_EKIPKOD
LEFT JOIN MUSTERI M
ON M.MUSTERI_KOD = A.AVANSLAR_MUSTERIKOD

/*------ 10:19:13 --------*/
ROLLBACK WORK

/*------ 22.04.2004 15:44:23 --------*/

select
PERSONELKOD,PERSONELADSOYAD
from PERSONEL
where PERSONELEKIPKODU = :EKIPKOD

/*------ 22.04.2004 15:44:31 --------*/

select
PERSONELKOD,PERSONELADSOYAD
from PERSONEL
where PERSONELEKIPKODU = :EKIPKOD

/*------ 22.04.2004 15:44:37 --------*/

select
PERSONELKOD,PERSONELADSOYAD
from PERSONEL
where PERSONELEKIPKODU = :EKIPKOD

/*------ 15:47:30 --------*/
ROLLBACK WORK

/*------ 22.04.2004 16:02:47 --------*/

delete from harcirah

/*------ 22.04.2004 16:02:50 --------*/

COMMIT WORK

/*------ 22.04.2004 16:04:16 --------*/

ALTER TABLE HARCIRAH DROP CONSTRAINT FK_HARCIRAH

/*------ 16:04:26 --------*/
COMMIT WORK

/*------ 16:04:37 --------*/
ROLLBACK WORK