1
DELETE FROM dbo.MDB_GOODS
2
DELETE FROM dbo.MDB_STYLE
3
DELETE FROM dbo.MDB_SERIES
4
DELETE FROM dbo.MDB_BCLASS
5
DELETE FROM dbo.MDB_MCLASS
6
DELETE FROM dbo.MDB_SIZE
7
DELETE FROM dbo.MDB_SIZE_GROUP
8![](/Images/OutliningIndicators/None.gif)
9![](/Images/OutliningIndicators/None.gif)
10
INSERT INTO dbo.MDB_SERIES
11
(SERIES_ID, SERIES_NAME, [DESCRIBE], SYSTEM_ID)
12
SELECT SERIES_ID, SERIES_NAME, [DESCRIBE], SYSTEM_ID
13
FROM
14
OPENDATASOURCE(
15
'SQLOLEDB',
16
'Data Source=192.168.1.246;User ID=sa;Password=sa'
17
).ln_tj060216.dbo.SERIES as a
18
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_SERIES b WHERE b.SERIES_ID=a.SERIES_ID)
19![](/Images/OutliningIndicators/None.gif)
20
INSERT INTO dbo.MDB_MCLASS
21
(MCLASS_ID, MCLASS_NAME, [DESCRIBE], SYSTEM_ID)
22
SELECT MCLASS_ID, MCLASS_NAME, [DESCRIBE], SYSTEM_ID
23
FROM
24
OPENDATASOURCE(
25
'SQLOLEDB',
26
'Data Source=192.168.1.246;User ID=sa;Password=sa'
27
).ln_tj060216.dbo.MCLASS as a
28
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_MCLASS b WHERE b.MCLASS_ID=a.MCLASS_ID)
29![](/Images/OutliningIndicators/None.gif)
30
INSERT INTO dbo.MDB_BCLASS
31
( MCLASS_ID, BCLASS_ID, BCLASS_NAME, [DESCRIBE], SYSTEM_ID)
32
SELECT MCLASS_ID, BCLASS_ID, BCLASS_NAME, [DESCRIBE], SYSTEM_ID
33
FROM
34
OPENDATASOURCE(
35
'SQLOLEDB',
36
'Data Source=192.168.1.246;User ID=sa;Password=sa'
37
).ln_tj060216.dbo.BCLASS as a
38
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_BCLASS b WHERE b.MCLASS_ID=a.MCLASS_ID AND a.bclass_id=a.bclass_id)
39![](/Images/OutliningIndicators/None.gif)
40
INSERT INTO dbo.MDB_SIZE_GROUP
41
( SIZEG_ID, SIZEG_NAME, SYSTEM_ID)
42
SELECT SIZEG_ID, SIZEG_NAME, SYSTEM_ID
43
FROM
44
OPENDATASOURCE(
45
'SQLOLEDB',
46
'Data Source=192.168.1.246;User ID=sa;Password=sa'
47
).ln_tj060216.dbo.SIZE_GROUP as a
48
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_SIZE_GROUP b WHERE b.SIZEG_ID=a.SIZEG_ID)
49![](/Images/OutliningIndicators/None.gif)
50![](/Images/OutliningIndicators/None.gif)
51![](/Images/OutliningIndicators/None.gif)
52
INSERT INTO dbo.MDB_SIZE
53
( SIZEG_ID, [SIZE], SYSTEM_ID, SORT)
54
SELECT SIZEG_ID, [SIZE], SYSTEM_ID, SORT
55
FROM
56
OPENDATASOURCE(
57
'SQLOLEDB',
58
'Data Source=192.168.1.246;User ID=sa;Password=sa'
59
).ln_tj060216.dbo.SIZE as a
60
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_SIZE b WHERE b.SIZEG_ID=a.SIZEG_ID and a.size=b.size)
61![](/Images/OutliningIndicators/None.gif)
62![](/Images/OutliningIndicators/None.gif)
63![](/Images/OutliningIndicators/None.gif)
64![](/Images/OutliningIndicators/None.gif)
65![](/Images/OutliningIndicators/None.gif)
66
INSERT INTO dbo.MDB_STYLE
67
(SYSTEM_ID, STYLE_TYPE, SIZEG_ID, MCLASS_ID, BCLASS_ID, SERIES_ID,
68
COLLECTION, PAGE, BRAND_NAME, YEARS, SEASON, RETAIL_PRICE, UNIT,
69
GENDER, STYLE_NAME, E_NAME, [DESCRIBE], UPDATE_DATE, CLOSE_DATE,
70
TAX_RATE, BORG_ID, SEC_CLASS_ID, PLAYGROUND, PERIOD_START,
71
PERIOD_END, MATERIAL_DESCRIBE, STYLIST, ATTRIB1_VALUE, ATTRIB2_VALUE,
72
ATTRIB3_VALUE, ATTRIB4_VALUE, ATTRIB5_VALUE)
73
SELECT SYSTEM_ID, STYLE_TYPE, SIZEG_ID, MCLASS_ID, BCLASS_ID, SERIES_ID,
74
COLLECTION, PAGE, BRAND_NAME, YEARS, SEASON, RETAIL_PRICE, UNIT,
75
GENDER, STYLE_NAME, E_NAME, [DESCRIBE], UPDATE_DATE, CLOSE_DATE,
76
TAX_RATE, BORG_ID, SEC_CLASS_ID, PLAYGROUND, PERIOD_START,
77
PERIOD_END, MATERIAL_DESCRIBE, STYLIST, null, null,
78
null, null, null
79
FROM
80
OPENDATASOURCE(
81
'SQLOLEDB',
82
'Data Source=192.168.1.246;User ID=sa;Password=sa'
83
).ln_tj060216.dbo.STYLE as a
84
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_STYLE b WHERE b.STYLE_TYPE=a.STYLE_TYPE )
85![](/Images/OutliningIndicators/None.gif)
86![](/Images/OutliningIndicators/None.gif)
87
INSERT INTO dbo.MDB_GOODS
88
( GOODS_NO, COLOR_SEQ, SYSTEM_ID, STYLE_TYPE, SIZEG_ID, [SIZE],
89
STYLE_NO, UNIT, RETAIL_PRICE, COLOR_MAIN, BARCODE, STATUS,
90
COLOR_MATCH, COLOR_NAME, BARCODE2, Start_Date
91
)
92
SELECT GOODS_NO, COLOR_SEQ, SYSTEM_ID, STYLE_TYPE, SIZEG_ID, [SIZE],
93
STYLE_NO, UNIT, RETAIL_PRICE, COLOR_MAIN, BARCODE, STATUS,
94
COLOR_MATCH, COLOR_NAME, BARCODE2, NULL
95
FROM
96
OPENDATASOURCE(
97
'SQLOLEDB',
98
'Data Source=192.168.1.246;User ID=sa;Password=sa'
99
).ln_tj060216.dbo.goods as a
100
WHERE NOT EXISTS (SELECT 1 FROM dbo.MDB_GOODS b WHERE b.goods_no=a.goods_no )
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
33
![](/Images/OutliningIndicators/None.gif)
34
![](/Images/OutliningIndicators/None.gif)
35
![](/Images/OutliningIndicators/None.gif)
36
![](/Images/OutliningIndicators/None.gif)
37
![](/Images/OutliningIndicators/None.gif)
38
![](/Images/OutliningIndicators/None.gif)
39
![](/Images/OutliningIndicators/None.gif)
40
![](/Images/OutliningIndicators/None.gif)
41
![](/Images/OutliningIndicators/None.gif)
42
![](/Images/OutliningIndicators/None.gif)
43
![](/Images/OutliningIndicators/None.gif)
44
![](/Images/OutliningIndicators/None.gif)
45
![](/Images/OutliningIndicators/None.gif)
46
![](/Images/OutliningIndicators/None.gif)
47
![](/Images/OutliningIndicators/None.gif)
48
![](/Images/OutliningIndicators/None.gif)
49
![](/Images/OutliningIndicators/None.gif)
50
![](/Images/OutliningIndicators/None.gif)
51
![](/Images/OutliningIndicators/None.gif)
52
![](/Images/OutliningIndicators/None.gif)
53
![](/Images/OutliningIndicators/None.gif)
54
![](/Images/OutliningIndicators/None.gif)
55
![](/Images/OutliningIndicators/None.gif)
56
![](/Images/OutliningIndicators/None.gif)
57
![](/Images/OutliningIndicators/None.gif)
58
![](/Images/OutliningIndicators/None.gif)
59
![](/Images/OutliningIndicators/None.gif)
60
![](/Images/OutliningIndicators/None.gif)
61
![](/Images/OutliningIndicators/None.gif)
62
![](/Images/OutliningIndicators/None.gif)
63
![](/Images/OutliningIndicators/None.gif)
64
![](/Images/OutliningIndicators/None.gif)
65
![](/Images/OutliningIndicators/None.gif)
66
![](/Images/OutliningIndicators/None.gif)
67
![](/Images/OutliningIndicators/None.gif)
68
![](/Images/OutliningIndicators/None.gif)
69
![](/Images/OutliningIndicators/None.gif)
70
![](/Images/OutliningIndicators/None.gif)
71
![](/Images/OutliningIndicators/None.gif)
72
![](/Images/OutliningIndicators/None.gif)
73
![](/Images/OutliningIndicators/None.gif)
74
![](/Images/OutliningIndicators/None.gif)
75
![](/Images/OutliningIndicators/None.gif)
76
![](/Images/OutliningIndicators/None.gif)
77
![](/Images/OutliningIndicators/None.gif)
78
![](/Images/OutliningIndicators/None.gif)
79
![](/Images/OutliningIndicators/None.gif)
80
![](/Images/OutliningIndicators/None.gif)
81
![](/Images/OutliningIndicators/None.gif)
82
![](/Images/OutliningIndicators/None.gif)
83
![](/Images/OutliningIndicators/None.gif)
84
![](/Images/OutliningIndicators/None.gif)
85
![](/Images/OutliningIndicators/None.gif)
86
![](/Images/OutliningIndicators/None.gif)
87
![](/Images/OutliningIndicators/None.gif)
88
![](/Images/OutliningIndicators/None.gif)
89
![](/Images/OutliningIndicators/None.gif)
90
![](/Images/OutliningIndicators/None.gif)
91
![](/Images/OutliningIndicators/None.gif)
92
![](/Images/OutliningIndicators/None.gif)
93
![](/Images/OutliningIndicators/None.gif)
94
![](/Images/OutliningIndicators/None.gif)
95
![](/Images/OutliningIndicators/None.gif)
96
![](/Images/OutliningIndicators/None.gif)
97
![](/Images/OutliningIndicators/None.gif)
98
![](/Images/OutliningIndicators/None.gif)
99
![](/Images/OutliningIndicators/None.gif)
100
![](/Images/OutliningIndicators/None.gif)