库存(十二).txt

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

USE [xc]

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].[库存] (
    [mc] [char] (10) NOT NULL, 
    [bh] [char] (10) NULL, 
    [sl] [char] (10) NOT NULL, 
)
ON [PRIMARY]
GO


SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


CREATE PROCEDURE 库存_setup
(
 
    @mc char (10), 
    @bh char (10),
    @sl char (10)
)

AS
insert 库存
(

    mc, 
    bh,
    sl
)

values
(
    @mc, 
    @bh,
    @sl
)