5.技术状态.sql
来自「一个很不错的实验室设备管理系统,用PB作为开发工具,具有一定的代表性.」· SQL 代码 · 共 3,650 行 · 第 1/5 页
SQL
3,650 行
293 ,
'N',
'设备类别' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'sybm',
'使用部门',
0 ,
'使用部门',
0,
23 ,
0 ,
77 ,
983 ,
'N',
'使用部门' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr1',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg1',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr2',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg2',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr3',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg3',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr4',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg4',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr5',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg5',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr6',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg6',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr7',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg7',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr8',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg8',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr9',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg9',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr10',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg10',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr11',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg11',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djnr12',
'点检内容',
0 ,
'点检内容',
0,
23 ,
0 ,
77 ,
1441 ,
'N',
'点检内容' ) ;
insert into "dba".pbcatcol
(pbc_tnam,
pbc_ownr,
pbc_cnam,
pbc_labl,
pbc_lpos,
pbc_hdr,
pbc_hpos,
pbc_jtfy,
pbc_case,
pbc_hght,
pbc_wdth,
pbc_bmap,
pbc_cmnt )
values
('sbztdj',
'dba',
'djjg12',
'点检结果',
0 ,
'点检结果',
0,
23 ,
0 ,
77 ,
293 ,
'N',
'点检结果' ) ;
insert into "dba".pbcatcol
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?