库存管理系统 mysql_SQL server 库存管理系统数据库

ALTER PROCEDURE dbo.InsertIntoStore

@GoodsName varchar(50),

@StoreName int,

@xiongjing varchar(50),

@dijing varchar (50),

@pengjing varchar (50),

@gaodu varchar (50),

@fenzhi varchar (50),

@GoodsUnit int,

@GoodsNum bigint,

@GoodsPrice decimal(18,2),

@ShouJia decimal(18,2),

@HandlePeople varchar (20),

@ISRemark varchar (1000),

@Pinzhi int,

@GYid int,

@IsGood bit,

@IsBareRoot bit

AS

----判断tb_GoodsName中是否已经存在要插入的名称，如果存在则取得GoodsId，不存在则插入后取得GoodsId

if exists (select GoodsId from tb_GoodsName where GoodsName=@GoodsName)

begin

declare @sql nvarchar(1000)

declare @gid int

set @sql= 'select @gid=GoodsId from tb_GoodsName where Goods