|
1
|
??U S E [ T C S D B ]
|
|
2
|
|
|
3
|
G O
|
|
4
|
|
|
5
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ T T _ C H E C K _ P R O C E S S ] S c r i p t D a t e : 1 / 2 0 / 2 0 2 4 3 : 3 7 : 4 0 P M * * * * * * /
|
|
6
|
|
|
7
|
S E T A N S I _ N U L L S O N
|
|
8
|
|
|
9
|
G O
|
|
10
|
|
|
11
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
|
12
|
|
|
13
|
G O
|
|
14
|
|
|
15
|
C R E A T E T A B L E [ d b o ] . [ T T _ C H E C K _ P R O C E S S ] (
|
|
16
|
|
|
17
|
[ i d ] [ b i g i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
|
|
18
|
|
|
19
|
[ Q R K A N B A N ] [ v a r c h a r ] ( 2 5 5 ) N O T N U L L ,
|
|
20
|
|
|
21
|
[ S E R I A L ] [ v a r c h a r ] ( 5 0 ) N O T N U L L ,
|
|
22
|
|
|
23
|
[ P K L _ N O ] [ v a r c h a r ] ( 5 0 ) N U L L ,
|
|
24
|
|
|
25
|
[ P A R T _ I D ] [ v a r c h a r ] ( 5 0 ) N U L L ,
|
|
26
|
|
|
27
|
[ C U S T _ P A R T ] [ v a r c h a r ] ( 5 0 ) N U L L ,
|
|
28
|
|
|
29
|
[ O R D E R _ Q T Y ] [ i n t ] N U L L ,
|
|
30
|
|
|
31
|
[ P A C K E D _ Q T Y ] [ i n t ] N U L L ,
|
|
32
|
|
|
33
|
[ P A C K I N G _ D A T E ] [ v a r c h a r ] ( 2 0 ) N U L L ,
|
|
34
|
|
|
35
|
[ P A C K I N G _ T I M E ] [ v a r c h a r ] ( 1 0 ) N U L L ,
|
|
36
|
|
|
37
|
[ C U S T _ S E R I A L ] [ v a r c h a r ] ( 2 5 5 ) N U L L ,
|
|
38
|
|
|
39
|
C O N S T R A I N T [ P K _ T T _ C h e c k P r o c e s s ] P R I M A R Y K E Y C L U S T E R E D
|
|
40
|
|
|
41
|
(
|
|
42
|
|
|
43
|
[ i d ] A S C
|
|
44
|
|
|
45
|
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N , O P T I M I Z E _ F O R _ S E Q U E N T I A L _ K E Y = O F F ) O N [ P R I M A R Y ]
|
|
46
|
|
|
47
|
) O N [ P R I M A R Y ]
|
|
48
|
|
|
49
|
G O
|
|
50
|
|
|
51
|
|