更新数据库.sql

餐营的数据核算,模拟入库,出库,库存.对餐营的流程详细叙述

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CS_ITEM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CS_ITEM]
GO

CREATE TABLE [dbo].[CS_ITEM] (
	[CS_FWQ] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CS_DABASE] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_MAN] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[CS_PASS] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

INSERT CS_ITEM VALUES ('HP1','CYCOPY','SA','')


INSERT BUTTON(BUTTON_NAME,PBS,ACTIONLIST) VALUES('作废','销售管理单','XSGLD')

INSERT BUTTON(BUTTON_NAME,PBS,ACTIONLIST) VALUES('导出','销售管理单','XSGLD')

INSERT BUTTON (BUTTON_NAME,PBS,ACTIONLIST) VALUES('传输','销售管理单','XSGLD')