?? labmis_qcgl.sql
字號(hào):
create table dbo.labmis_qcgl
(qcbh char(4) not null,
qcmc nvarchar(60) null,
dj numeric(12,2) null,
gmrq datetime null,
gmdw nvarchar(60) null,
wxdwlxff text null,
yt text null,
syqk text null,
xgzlqk text null) ;
alter table dbo.labmis_qcgl
add constraint qcbh primary key nonclustered
(qcbh) ;
insert into dbo.pbcattbl
(pbt_tnam, pbt_tid, pbt_ownr,
pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce,
pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce,
pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce,
pbt_cmnt)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo',
-12, 400, 'N', 'N', 0, 34,
'Arial',
-12, 400, 'N', 'N', 0, 34,
'Arial',
-9, 400, 'N', 'N', 134, 2,
'宋體',
' ') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'qcbh', 1,
'Qcbh:', 0 ,
'Qcbh', 0,
23 , '',
0 , 77 , 161 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'qcmc', 2,
'Qcmc:', 0 ,
'Qcmc', 0,
23 , '',
0 , 77 , 1441 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'dj', 3,
'Dj:', 0 ,
'Dj', 0,
24 , '[General]',
0 , 77 , 389 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'gmrq', 4,
'Gmrq:', 0 ,
'Gmrq', 0,
23 , '',
0 , 77 , 481 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'gmdw', 5,
'Gmdw:', 0 ,
'Gmdw', 0,
23 , '',
0 , 77 , 1441 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'wxdwlxff', 6,
'Wxdw:', 0 ,
'Wxdw', 0,
23 , '',
0 , 77 , 5893 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'yt', 7,
'Yt:', 0 ,
'Yt', 0,
23 , '',
0 , 77 , 5893 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'syqk', 8,
'Syqk:', 0 ,
'Syqk', 0,
23 , '',
0 , 77 , 5893 ,
'', 'N',
'',
' ',
'', '') ;
insert into dbo.pbcatcol
(pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
values ( 'labmis_qcgl',
object_id('dbo.labmis_qcgl'),
'dbo', 'xgzlqk', 9,
'Xgzlqk:', 0 ,
'Xgzlqk', 0,
23 , '',
0 , 77 , 5893 ,
'', 'N',
'',
' ',
'', '') ;
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -