Project

General

Profile

1.0_CREATE_TABLE_AMS_GOLIVE_30_12_2022.sql

Luc Tran Van, 12/31/2022 02:32 PM

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