进销存软件触发器。用于仓储型公司。库存量的变化。

				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
				)