rsgz.pdb

医院管理系统

0



0
0
0
1
0
0
XM17

48
3
6617
6617
项目18
XM18



274
0
numeric(7,2)
7
2
0
0





0
0
0



0
0
0
1
0
0
XM18

49
3
6618
6618
项目19
XM19



274
0
numeric(7,2)
7
2
0
0





0
0
0



0
0
0
1
0
0
XM19

50
3
6619
6619
项目20
XM20



274
0
numeric(7,2)
7
2
0
0





0
0
0



0
0
0
1
0
0
XM20

51
3
304
304
假别
JBBM



303
0
varchar(10)
10
0
0
0





0
0
0



1
0
1
1
1158
8
JBBM

1
3
305
305
扣款比例
KKBL



303
0
numeric(6,2)
6
2
0
0





0
0
0



0
0
0
1
836
8
KKBL

2
3
306
306
扣款金额
KKJE



303
0
numeric(7,2)
7
2
0
0





0
0
0



0
0
0
1
838
8
KKJE

3
3
1552
1552
报表编码
BBBM



1551
0
varchar(10)
10
0
0
0





0
0
0



1
0
1
1
0
0
BBBM

1
3
1553
1553
行号
HH



1551
0
int
0
0
0
0





0
0
0



1
0
1
1
0
0
HH

2
3
1554
1554
列号
LH



1551
0
int
0
0
0
0





0
0
0



1
0
1
1
0
0
LH

3
3
1555
1555
显示值
XSZ



1551
0
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
XSZ

4
3
2070
2070
代码类别
DMLB
标志不同类别的代码


2069
0
numeric(4)
4
0
0
0





0
0
0



1
0
1
1
0
0
DMLB

1
3
2071
2071
代码识别
DMSB
代码识别序号, 大于0为代码识别序号, 小于等于0为代码类别说明


2069
0
numeric(8)
8
0
0
0





0
0
0



1
0
1
1
0
0
DMSB

2
3
2072
2072
输入代码
SRDM



2069
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
SRDM

3
3
2073
2073
代码名称
DMMC



2069
0
varchar(40)
40
0
0
0





0
0
0



0
0
0
1
0
0
DMMC

4
3
2074
2074
标准编码
BZBM



2069
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
BZBM

5
3
2075
2075
系统识别
XTSB



2069
0
numeric(4)
4
0
0
0




0
0
0
0



0
0
1
1
0
0
XTSB

6
3
4022
4022
列代码
LDM



4021
0
varchar(15)
15
0
0
0





0
0
0



0
0
1
1
0
0
LDM

1
3
4023
4023
列名称
LMC



4021
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
LMC

2
3
4024
4024
值代码
ZDM



4021
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
ZDM

3
3
4552
4552
值类型
ZLX



4021
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
ZLX

4
3
4025
4025
值名称
ZMC



4021
0
varchar(100)
100
0
0
0





0
0
0



0
0
0
1
0
0
ZMC

5
3
5263
5263
项目编码
XMBM



5262
0
varchar(10)
10
0
0
0





0
0
0



1
0
1
1
0
0
XMBM

1
3
5264
5264
项目名称
XMMC



5262
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
XMMC

2
3
5265
5265
扣款比例
KKBL



5262
0
numeric(6,2)
6
2
0
0





0
0
0



0
0
0
1
0
0
KKBL

3
3
5266
5266
扣款金额
KKJE



5262
0
numeric(7,2)
7
2
0
0





0
0
0



0
0
0
1
0
0
KKJE

4
/END_TABLE AMCCOLN

/BEGIN_TABLE AMCREFR
@       N5
OID     N8
REFR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL1   N8
TABL2   N8
URUL    N1
DRUL    N1
MAND    N1
CPRT    N1
SOID    N8
TOBJ    N5
COBJ    A80
FKCN    A30
CMIN    A10
CMAX    A10
NGEN    N1
/BEGIN_DATA AMCREFR
3
307
307
家庭成员
JTCY



1
44
1
1
1
1
518
7
JTCY

0
n
0
3
308
308
社会关系
SHGX



1
50
1
1
1
1
519
7
SHGX

0
n
0
3
309
309
工作经历
GZJL



1
56
1
1
1
1
520
7
GZJL

0
n
0
3
310
310
签订合同
QDHT



1
62
1
1
1
1
521
7
QDHT

0
n
0
3
313
313
人事变动记录
RSBDJL



1
76
1
1
1
1
523
7
RSBDJL

0
n
0
3
314
314
员工参保记录
YGCBJL



1
88
1
1
1
1
524
7
YGCBJL

0
n
0
3
315
315
培训记录
PXJL



1
94
1
1
1
1
525
7
PXJL

0
n
0
3
316
316
奖惩记录
JCJL



1
101
1
1
1
1
526
7
JCJL

0
n
0
3
319
319
养老金发放记录
YLJFFJL



1
143
1
1
1
1
528
7
YLJFFJL

0
n
0
3
322
322
考勤记录
KQJL



1
154
1
1
1
1
530
7
KQJL

0
n
0
3
323
323
人员分类
RYFL



1
233
1
1
1
1
531
7
RYFL

0
n
0
1
324
324
统计项目
TJXM



210
233
1
1
1
1
532
7
TJXM

1
n
0
3
325
325
工资核定
GZHD



1
248
1
1
1
1
533
7
GZHD

0
n
0
3
326
326
工资项目_工资核定
GZXM_GZHD



195
248
1
1
1
1
534
7
GZXM_GZHD

1
n
0
3
328
328
工资项目_工资调整
GZXM_GZTZ



195
234
1
1
1
1
536
7
GZXM_GZTZ

1
n
0
1
329
329
临时工人员档案
LSGRYDA



215
205
1
1
1
1
537
7
LSGRYDA

0
n
0
3
330
330
人员基本信息_考核档案
RYJBXX_KHDA



1
180
1
1
1
1
538
7
RYJBXX_KHDA

0
n
0
3
331
331
RSBB_HDY
RSBB_HDY



259
266
1
1
1
1
539
7
RSBB_HDY

0
n
0
3
332
332
RSBB_LDY
RSBB_LDY



259
270
1
1
1
1
540
7
RSBB_LDY

1
n
0
1
333
333
发放记录明细
JL_MX



252
274
1
1
1
1
541
7
JL_MX

0
n
0
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N8
CCOL    N8
COLN1   N8
COLN2   N8
/BEGIN_DATA AMCCCOL
1
336
336
2
335
1
339
339
2
338
1
342
342
2
341
1
345
345
2
344
1
351
351
2
350
1
354
354
2
353
1
357
357
2
356
1
360
360
2
359
1
366
366
2
365
1
372
372
2
371
1
375
375
2
374
1
378
378
2
377
1
384
384
2
383
1
390
390
211
389
1
393
393
212
392
1
396
396
196
395
1
399
399
196
398
1
402
402
216
401
1
405
405
260
404
1
408
408
260
407
1
411
411
253
410
1
414
414
254
413
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N8
CREF    N8
REFR    N8
CCOL    N8
NUMR    N8
/BEGIN_DATA AMCCREF
3
337
337
307
336
1
3
340
340
308
339
1
3
343
343
309
342
1
3
346
346
310
345
1
3
352
352
313
351
1
3
355
355
314
354
1
3
358
358
315
357
1
3
361
361
316
360
1
3
367
367
319
366
1
3
373
373
322
372
1
3
376
376
323
375
1
3
391
391
324
390
1
3
394
394
324
393
2
3
379
379
325
378
1
3
397
397
326
396
1
3
400
400
328
399
1
3
403
403
329
402
1
3
385
385
330
384
1
3
406
406
331
405
1
3
409
409
332
408
1
3
412
412
333
411
1
3
415
415
333
414
2
/END_TABLE AMCCREF

/BEGIN_TABLE AMCINDX
@       N5
OID     N8
INDX    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
PRIM    N1
FORN    N1
UNIQ    N1
CLUS    N1
OPTS    TXT
COBJ    A80
NUMR    N8
TYPE    A40
/BEGIN_DATA AMCINDX
3
433
433
RS_JTCY_PK
RS_JTCY_PK
44



1
0
1
0

PK
1

3
436
436
JTCY_FK
JTCY_FK
44



0
1
0
0

FK307
2

3
438
438
RS_SHGX_PK
RS_SHGX_PK
50



1
0
1
0

PK
3

3
441
441
SHGX_FK
SHGX_FK
50



0
1
0
0

FK308
4

3
443
443
RS_GZJL_PK
RS_GZJL_PK
56



1
0
1
0

PK
5

3
446
446
GZJL_FK
GZJL_FK
56



0
1
0
0

FK309
6

3
448
448
RS_QDHT_PK
RS_QDHT_PK
62



1
0
1
0

PK
7

3
451
451
QDHT_FK
QDHT_FK
62



0
1
0
0

FK310
8

3
453
453
RS_RYJS_PK
RS_RYJS_PK
67



1
0
1
0

PK
9

3
457
457
RS_RSBD_PK
RS_RSBD_PK
76



1
0
1
0

PK
10

3
460
460
RSBDJL_FK
RSBDJL_FK
76



0
1
0
0

FK313
11

3
462
462
RS_YGCB_PK
RS_YGCB_PK
88



1
0
1
0

PK
12

3
466
466
YGCBJL_FK
YGCBJL_FK
88



0
1
0
0

FK314
13

3
468
468
RS_PXJL_PK
RS_PXJL_PK
94



1
0
1
0

PK
14

3
471
471
PXJL_FK
PXJL_FK
94



0
1
0
0

FK315
15

3
473
473
RS_JCJL_PK
RS_JCJL_PK
101



1
0
1
0

PK
16

3
476
476
JCJL_FK
JCJL_FK
101



0
1
0
0

FK316
17

3
478
478
RS_TXSP_PK
RS_TXSP_PK
112



1
0
1
0

PK
18

3
482
482
RS_YLJFF_PK
RS_YLJFF_PK
143



1
0
1
0

PK
19

3
486
486
YLJFFJL_FK
YLJFFJL_FK
143



0
1
0
0

FK319
20

3
488
488
RS_LTJS_PK
RS_LTJS_PK
149



1
0
1
0

PK
21

3
492
492
RS_KQJL_PK
RS_KQJL_PK
154



1
0
1
0

PK
22

3
496
496
KQJL_FK
KQJL_FK
154



0
1
0
0

FK322
23

3
498
498
RS_KHDA_PK
RS_KHDA_PK
180



1
0
1
0

PK
24

3
501
501
RYJBXX_KHDA_FK
RYJBXX_KHDA_FK
180



0
1
0
0

FK330
25

3
503
503
RS_GZXM_PK
RS_GZXM_PK
195



1
0
1
0

PK
26

3
505
505
RS_LSGGZ_PK
RS_LSGGZ_PK
205



1
0
1
0

PK
27

3
508
508
LSGRYDA_FK
LSGRYDA_FK
205



0
1
0
0

FK329
28

3
510
510
RS_TJXM_PK
RS_TJXM_PK
210



1
0
1
0

PK
29

3
513
513
RS_LSGDA_PK
RS_LSGDA_PK
215



1
0
1
0

PK
30

3
515
515
RS_RYFL_PK
RS_RYFL_PK
233



1
0
1
0

PK
31

3
519
519
RYFL_FK
RYFL_FK
233



0
1
0
0

FK323
32

3
521
521
TJXM_FK
TJXM_FK
233



0
1
0
0

FK324
33

3
524
524
RS_GZTZ_PK
RS_GZTZ_PK
234



1
0
1
0

PK
34

3
528
528
GZJTTZJL_FK
GZJTTZJL_FK
234



0
1
0
0

FK327
35

3
530
530
GZXM_GZTZ_FK
GZXM_GZTZ_FK
234



0
1
0
0

FK328
36

3
532
532
RS_SLB_PK
RS_SLB_PK
241



1
0
1
0

PK
37

3
534
534
RS_GZHD_PK
RS_GZHD_PK
248



1
0
1
0

PK
38

3
537
537
GZHD_FK
GZHD_FK
248



0
0
0
0

FK325
39

3
539
539
GZXM_GZHD_FK
GZXM_GZHD_FK
248



0
1
0
0

FK326
40

3
541
541
RS_GZFFJL_PK
RS_GZFFJL_PK
252



1
0
1
0

PK
41

3
544
544
RS_RSBB_PK
RS_RSBB_PK
259



1
0
1
0

PK
42

3
546
546
RS_BBHDY_PK
RS_BBHDY_PK
266



1
0
1
0

PK
43

3
549
549
RSBB_HDY_FK
RSBB_HDY_FK
266



0
1
0
0

FK331
44

3
551
551
RS_BBLDY_PK
RS_BBLDY_PK
270



1
0
1
0

PK
45

3
554
554
RSBB_LDY_FK
RSBB_LDY_FK
270



0
1
0
0

FK332
46

3
556
556
RS_GZFFMX_PK
RS_GZFFMX_PK
274



1
0
1
0

PK
47

3
560
560
JL_MX_FK
JL_MX_FK
274



0
1
0
0

FK333
48

3
563
563
RELATION_3472_FK
RELATION_3472_FK
274



0
1
0
0

FK334
49

3
565
565
RS_JBSZ_PK
RS_JBSZ_PK
303



1
0
1
0

PK
50

/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N8
CIDX    N8
INDX    N8
COLN    N8
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
3
434
434
433
335
1
1
3
435
435
433
45
1
2
3
437
437
436
335
1
1
3
439
439
438
338
1
1
3
440
440
438
51
1
2
3
442
442
441
338
1
1
3
444
444
443
341
1
1
3
445
445
443
57
1
2
3
447
447
446
341
1
1
3
449
449
448
344
1
1
3
450
450
448
63
1
2
3
452
452
451
344
1
1
3
454
454
453
347
1
1
3
458
458
457
350
1
1
3
459
459
457
77
1
2
3
461
461
460
350
1
1
3
463
463
462
353
1
1
3
464
464
462
89
1
2
3
465
465
462
90
1
3
3
467
467
466
353
1
1
3
469
469
468
356
1
1
3
470
470
468
95
1
2
3
472
472
471
356
1
1
3
474
474
473
359
1
1
3
475
475
473
102
1
2
3
477
477
476
359
1
1
3
479
479
478
362
1
1
3
483
483
482
365
1
1
3
484
484
482
144
1
2
3
485
485
482
145
1
3
3
487
487
486
365
1
1
3
489
489
488
368
1
1
3
493
493
492
371
1
1
3
494
494
492
155
1
2
3
495
495
492
156
1
3
3
497
497
496
371
1
1
3
499
499
498
383
1
1
3
502
502
501
383
1
1
3
504
504
503
196
1
1
3
506
506
505
401
1
1
3
507
507
505
206
1
2
3
509
509
508
401
1
1
3
511
511
510
211
1
1
3
512
512
510
212
1
2
3
514
514
513
216
1
1
3
516
516
515
389
1
1
3
517
517
515
392
1
2
3
518
518
515
374
1
3
3
520
520
519
374
1
1
3
522
522
521
389
1
1
3
523
523
521
392
1
2
3
525
525
524
398
1
1
3
526
526
524
380
1
2
3
527
527
524
235
1
3
3
529
529
528
380
1
1
3
531
531
530
398
1
1
3
533
533
532
242
1
1
3
535
535
534
395
1
1
3
536
536
534
377
1
2
3
538
538
537
377
1
1
3
540
540
539
395
1
1
3
542
542
541
253
1
1
3
543
543
541
254
1
2
3
545
545
544
260
1
1
3
547
547
546
404
1
1
3
548
548
546
267
1
2
3
550
550
549
404
1
1
3
552
552
551
407
1
1
3
553
553
551
271
1
2
3
555
555
554
407
1
1
3
557
557
556
410
1
1
3
558
558
556
413
1
2
3
559
559
556
386
1
3
3
561
561
560
410
1
1
3
562
562
560
413
1
2
3
564
564
563
386
1
1
3
566
566
565
304
1
1
/END_TABLE AMCCIDX

/BEGIN_TABLE AMCAKEY
@       N5
OID     N8
AKEY    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
AKCN    A30
NUMR    N8
/BEGIN_DATA AMCAKEY
/END_TABLE AMCAKEY

/BEGIN_TABLE AMCCKEY
@       N5
OID     N8
CKEY    N8
AKEY    N8
COLN    N8
NUMR    N8
/BEGIN_DATA AMCCKEY
/END_TABLE AMCCKEY

/BEGIN_TABLE AMCTRGR
@       N5
TEMP    A30
TEXT    TXT
NAME    A30
TABL    N8
ALWS    N1
/BEGIN_DATA AMCTRGR
/END_TABLE AMCTRGR

/BEGIN_TABLE AMCPROC
@       N5
OID     N8
PROC    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TEXT    TXT
FUNC    N1
/BEGIN_DATA AMCPROC
3
6599
6599
sp_rs_bbtj
SP_RS_BBTJ



create procedure sp_rs_bbtj as\
begin\
delete from RS_BBTJ\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'KSDM','??',KSDM,'NUMBER',KSMC\
FROM GY_KSDM\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGDM','????',YGDM,'STRING',YGDM\
FROM RS_JBXX\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGXM','????',YGXM,'STRING',YGXM\
FROM RS_JBXX\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'ZJFS','????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 1\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGXB','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 15\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGCF','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 40\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'HKXZ','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 41\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGMZ','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 1\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'JGDZ','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 3\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'ZZMM','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 42\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'HYZK','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 5\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'WHCD','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 43\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'XW','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 46\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'XL','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 47\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YZ','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 49\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'CSZY','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 45\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGZC','??',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 2\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'YGZW','??',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 26\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'JSRY','??????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 3\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'RYXZ','????',DMSB,'NUMBER',DMMC\
FROM GY_DMZD WHERE DMSB <> 0 and DMLB = 51\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'ZGZG','??????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 4\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'QTCYRY','????????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 5\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'JSFS','????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 6\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'TXZL','????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 8\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT 'TXJSYY','??????',DMSB,'NUMBER',DMMC\
FROM RS_DMZD WHERE DMSB <> 0 and DMLB = 9\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('CBBZ','????','0','NUMBER','???')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('CBBZ','????','1','NUMBER','???')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('RYZT','????','0','STRING','??')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('RYZT','????','1','STRING','??')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('RYZT','????','2','STRING','??')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
VALUES('RYZT','????','3','STRING','????')\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT TJXMBM,TJXMMC, FLBM, 'STRING', FLMC  \
FROM RS_TJXM  \
\
///////////////////////////\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT DISTINCT 'BDSJ','????',CONVERT(CHAR(10),BDSJ,120),'DATETIME',CONVERT(CHAR(10),BDSJ,120)\
FROM RS_JBXX\
\
INSERT INTO RS_BBTJ(LDM,LMC,ZDM,ZLX,ZMC)\
SELECT DISTINCT 'CSNY','????',CONVERT(CHAR(10),CSNY,120),'DATETIME',CONVERT(CHAR(10),CSNY,120)\
FROM RS_JBXX\
\
INSER