有两个表是货品信息表和货品入库表我想直接删除货品信息表中的内容是不允许的,而必须先删除货品入库表里的相关信息后才能删除货品信息表里的内容。哪位能帮忙实现???谢谢。
货品信息表字段
ID int 4 0 --设为主键
GoodsID varchar 20 0
GoodsName varchar 30
StoreName varchar 30
GoodsSpec varchar 30
GoodsUnit char 8
GoodsNum int 4
GoodsInPrice money 8
GoodsOutPrice money 8
GoodsLeast bigint 8
GoodsMost bigint 8
货品入库表字段: ID int 4 0
ISID varchar 20 0--设为主键 GoodsID varchar 20 0
GoodsName varchar 30
PrName varchar 30 1
StoreName varchar 30
GoodsSpec varchar 30
GoodsUnit char 8
GoodsNum int 4
GoodsPrice money 8
GoodsAPrice money 8
ISDate datetime 8
HandlePeople varchar 20
ISRe varchar 50
货品信息表字段
ID int 4 0 --设为主键
GoodsID varchar 20 0
GoodsName varchar 30
StoreName varchar 30
GoodsSpec varchar 30
GoodsUnit char 8
GoodsNum int 4
GoodsInPrice money 8
GoodsOutPrice money 8
GoodsLeast bigint 8
GoodsMost bigint 8
货品入库表字段: ID int 4 0
ISID varchar 20 0--设为主键 GoodsID varchar 20 0
GoodsName varchar 30
PrName varchar 30 1
StoreName varchar 30
GoodsSpec varchar 30
GoodsUnit char 8
GoodsNum int 4
GoodsPrice money 8
GoodsAPrice money 8
ISDate datetime 8
HandlePeople varchar 20
ISRe varchar 50
Create PROCEDURE [dbo].[TempProce]
@GoodsID int,
@Result bit out
AS
BEGIN
declare @count int
select @count=count(*) from [货品入库表] Where ID =@GoodsID
if(@count>0)
set @Result =0
else
begin
set @Result = 1
delete from [货品信息表] where GoodsID = @GoodsID
end
END
然后接受@Result的值来判断是否删除成功
货品入库表中加 ID int foreign key references 货品信息表名(ID)