sb_zcsb_yz.sql

来自「一套PB开发的工商行政管理全套源码,包括企业登记,执照,案件管理等.」· SQL 代码 · 共 11 行

use hrb
go
alter table dbo.sb_zcsb_yz add yznd char(4) null, scyznd char(4) null, sbwt char(1) null
go
update dbo.pbcattbl set pbd_fhgt = -10, pbd_fwgt = 400, pbd_fitl = 'N', pbd_funl = 'N', pbd_fchr = 0, pbd_fptc = 34, pbd_ffce = 'Arial', pbh_fhgt = -10, pbh_fwgt = 700 , pbh_fitl = 'N', pbh_funl = 'N', pbh_fchr = 0, pbh_fptc = 34, pbh_ffce = 'Arial', pbl_fhgt = -10, pbl_fwgt = 400 , pbl_fitl = 'Y', pbl_funl = 'N', pbl_fchr = 0, pbl_fptc = 34, pbl_ffce = 'Arial', pbt_cmnt = '注册商标验证表' where pbt_tid = object_id('dbo.sb_zcsb_yz')
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 ( 'sb_zcsb_yz', object_id('dbo.sb_zcsb_yz'), 'dbo', 'yznd', 50, '', 0 , '', 0, 23 , '', 0 , 65 , 129 , '', '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 ( 'sb_zcsb_yz', object_id('dbo.sb_zcsb_yz'), 'dbo', 'scyznd', 51, '', 0 , '', 0, 23 , '', 0 , 65 , 129 , '', '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 ( 'sb_zcsb_yz', object_id('dbo.sb_zcsb_yz'), 'dbo', 'sbwt', 52, '', 0 , '', 0, 23 , '', 0 , 65 , 69 , '', 'N', '', '', '', '')
go
update sb_zcsb_yz set yznd=convert(char(4),sbyzrq,112)
go