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] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bdbh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[hdsj] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[jfjbr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[xmzj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gczj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[yyzj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[lcdd] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[sj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[lc] [char] (400) COLLATE Chinese_PRC_CI_AS NULL ,
[sm] [char] (400) COLLATE Chinese_PRC_CI_AS NULL ,
[fzr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[zcrcc] [char] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
[yx] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[jcdg] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[dndx] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[sp] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[tx] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[bz] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
)
ON [PRIMARY]
GO


SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE 項目活動流程及執行腳本_setup
(
@xmbh char (20),
@bdbh char (20),
@hdsj char (30),
@jfjbr char (20),
@xmzj char (20),
@gczj char (20),
@yyzj char (20),
@lcdd char (20),
@sj char (20),
@lc char (400),
@sm char (400),
@fzr char (20),
@zcrcc char (4000),
@yx char (200),
@jcdg char (200),
@dndx char (200),
@sp char (200),
@tx char (200),
@bz char (500)
)

AS
insert 項目活動流程及執行腳本
(
xmbh,
bdbh,
hdsj,
jfjbr,
xmzj,
gczj,
yyzj,
lcdd,
sj,
lc,
sm,
fzr,
zcrcc,
yx,
jcdg,
dndx,
sp,
tx,
bz
)

values
(
@xmbh,
@bdbh,
@hdsj,
@jfjbr,
@xmzj,
@gczj,
@yyzj,
@lcdd,
@sj,
@lc,
@sm,
@fzr,
@zcrcc,
@yx,
@jcdg,
@dndx,
@sp,
@tx,
@bz
)