USE [xc]
GO
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 ,
[xmdw] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[xmdd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[bdsj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bddd] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[kssj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[jssj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xycp] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sm] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[hzsrs] [char] (10) NULL ,
[xm] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[gzap] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[hzx1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hzx2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tsx] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[clap] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[yrss] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[xm2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[lb] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[sl] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bysj] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[yqsm] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[jsfs] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[mc] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[sl2] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[bh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bz] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[bzsm] [char] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[xmzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[kfzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[cwzj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[zjl] [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 datetime ,
@xmdw char (60) ,
@xmdd char (100) ,
@bdsj datetime ,
@bddd char (100) ,
@kssj datetime ,
@jssj datetime ,
@xycp char (10) ,
@sm char (200) ,
@hzsrs char (10) ,
@xm char (60) ,
@gzap char (200) ,
@hzx1 char (50) ,
@hzx2 char (50) ,
@tsx char (50) ,
@clap char (200) ,
@yrss char (200) ,
@xm2 char (20) ,
@lb char (20) ,
@sl char (20) ,
@bysj char (50) ,
@yqsm char (500) ,
@jsfs char (200) ,
@mc char (100) ,
@sl2 char (40) ,
@bh char (20) ,
@bz char (500) ,
@bzsm char (1000) ,
@xmzj char (10) ,
@kfzj char (10) ,
@cwzj char (10) ,
@zjl char (10)
)
AS
insert 项目监理对演艺中心沟通单
(
xmbh ,
bdbh ,
hdsj ,
xmdw ,
xmdd ,
bdsj ,
bddd ,
kssj ,
jssj ,
xycp ,
sm ,
hzsrs ,
xm ,
gzap ,
hzx1 ,
hzx2 ,
tsx ,
clap ,
yrss ,
xm2 ,
lb ,
sl ,
bysj ,
yqsm ,
jsfs ,
mc ,
sl2 ,
bh ,
bz ,
bzsm ,
xmzj ,
kfzj ,
cwzj ,
zjl
)
values
(
@xmbh ,
@bdbh ,
@hdsj ,
@xmdw ,
@xmdd ,
@bdsj ,
@bddd ,
@kssj ,
@jssj ,
@xycp ,
@sm ,
@hzsrs ,
@xm ,
@gzap ,
@hzx1 ,
@hzx2 ,
@tsx ,
@clap ,
@yrss ,
@xm2 ,
@lb ,
@sl ,
@bysj ,
@yqsm ,
@jsfs ,
@mc ,
@sl2 ,
@bh ,
@bz ,
@bzsm ,
@xmzj ,
@kfzj ,
@cwzj ,
@zjl
)
