项目对讲机领用（表十一）.txt

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

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 ,
[fxm] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[lyr] [char] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[lysj] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[lybh] [char] (400) COLLATE Chinese_PRC_CI_AS NULL ,
[ghsj] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[brqz] [char] (600) 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),
@fxm char (500),
@lyr char (500),
@lysj char (40),
@lybh char (400),
@ghsj char (40),
@brqz char (600)
)

AS
insert 项目对讲机领用
(
xmbh,
bdbh,
hdsj,
fxm,
lyr,
lysj,
lybh,
ghsj,
brqz
)

values
(
@xmbh,
@bdbh,
@hdsj,
@fxm,
@lyr,
@lysj,
@lybh,
@ghsj,
@brqz
)