if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[项目人员分工明细及考核]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[项目人员分工明细及考核]
GO
CREATE TABLE [dbo].[项目人员分工明细及考核] (
[xmbh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[bdbh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[hdsj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bdcyr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xmdw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[xmmc] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[xmzj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gczj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xmdd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[lcdd] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xmzl] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xmjl] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[qy] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[fzr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gznr] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[yqsj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[sjsj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ccgz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[ccqk] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[gznr2] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[wcqk] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[cd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[zt] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[zzps] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[zhsz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[xljm] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[gzzt] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[zhdf] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
)
ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE 项目人员分工明细及考核_setup
(
@xmbh char (30) ,
@bdbh char (20) ,
@hdsj char (20) ,
@bdcyr char (20) ,
@xmdw char (10) ,
@xmmc char (80) ,
@xmzj char (20) ,
@gczj char (20) ,
@xmdd char (100) ,
@lcdd char (20) ,
@xmzl char (20) ,
@xmjl char (10) ,
@sj char (20) ,
@qy char (60) ,
@fzr char (20) ,
@gznr char (200) ,
@yqsj char (20) ,
@sjsj char (20) ,
@ccgz char (200) ,
@ccqk char (200) ,
@gznr2 char (200) ,
@wcqk char (200) ,
@cd char (100) ,
@zt char (100) ,
@zzps char (100) ,
@zhsz char (100) ,
@xljm char (100) ,
@gzzt char (200) ,
@zhdf char (10)
)
AS
insert 项目人员分工明细及考核
(
xmbh ,
bdbh ,
hdsj ,
bdcyr ,
xmdw ,
xmmc ,
xmzj ,
gczj ,
xmdd ,
lcdd ,
xmzl ,
xmjl ,
sj ,
qy ,
fzr ,
gznr ,
yqsj ,
sjsj ,
ccgz ,
ccqk ,
gznr2 ,
wcqk ,
cd ,
zt ,
zzps ,
zhsz ,
xljm ,
gzzt ,
zhdf
)
values
(
@xmbh ,
@bdbh ,
@hdsj ,
@bdcyr ,
@xmdw ,
@xmmc ,
@xmzj ,
@gczj ,
@xmdd ,
@lcdd ,
@xmzl ,
@xmjl ,
@sj ,
@qy ,
@fzr ,
@gznr ,
@yqsj ,
@sjsj ,
@ccgz ,
@ccqk ,
@gznr2 ,
@wcqk ,
@cd ,
@zt ,
@zzps ,
@zhsz ,
@xljm ,
@gzzt ,
@zhdf
)
