CREATE proc sp__addpro
@pro_sort int,
@pro_code varchar(50),
@pro_name varchar(50)
AS
BEGIN TRAN addpro
declare @proID int
--添加数据到产品表
INSERT INTO PDM_product(pro_sort,pro_code,pro_name)
VALUES(@pro_sort,@pro_code,@pro_name)
---得到proid的值
SELECT
@proID = @@Identity
---将数据写入库存表
insert into pdm_batch(pro_id,pro_storage)
select @proID,b.storage_id from pdm_storage b group by b.storage_id
-----
结果库存表的值都会多出几条记录,不知道为什么
@pro_sort int,
@pro_code varchar(50),
@pro_name varchar(50)
AS
BEGIN TRAN addpro
declare @proID int
--添加数据到产品表
INSERT INTO PDM_product(pro_sort,pro_code,pro_name)
VALUES(@pro_sort,@pro_code,@pro_name)
---得到proid的值
SELECT
@proID = @@Identity
---将数据写入库存表
insert into pdm_batch(pro_id,pro_storage)
select @proID,b.storage_id from pdm_storage b group by b.storage_id
-----
结果库存表的值都会多出几条记录,不知道为什么
select @proID,b.storage_id from pdm_storage b group by b.storage_id
估计是这里select 出来的值不只一条。