Create Table Receiving(
    id_Declare varchar(15) NOT NULL,
    id_Goods varchar(15) NOT NULL,
    id_Creator varchar(15) NOT NULL,
    Price varchar(15) NOT NULL,
    Number varchar(5) NOT NULL

    , primary key (
        id_Declare
        , id_Goods
    )
)

USE ITStore
GO
INSERT INTO Receiving
VALUES ('1', '1', '101','750','2');
GO

USE ITStore
GO
INSERT INTO Receiving
VALUES ('1', '1', '101','750','2');
GO

USE ITStore
GO
INSERT INTO Receiving
VALUES ('2', '2', '102','1250','2');
GO

USE ITStore
GO
INSERT INTO Receiving
VALUES ('3', '3', '103','750','2');
GO

USE ITStore
GO
INSERT INTO Receiving
VALUES ('4', '4', '101','1350','1');
GO

USE ITStore
GO
INSERT INTO Receiving
VALUES ('5', '5', '105','750','2');
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE Receiving
	-- Add the parameters for the stored procedure here
	@id_Declare int, 
	@id_Goods int,
	@id_Creator int,
	@Price int,
	@Number int
AS
declare @v_id integer
 DECLARE cur_cust_id CURSOR FOR
 SELECT MAX(id_Declare) 
 FROM dbo.Receiving

BEGIN
 open cur_cust_id
 fetch cur_cust_id into @v_id
 
   INSERT INTO Receiving
           (id_Declare
           ,id_Goods
           ,id_Creator
           ,Price
           ,Number
           )
     VALUES
           (@v_id+1, 
	       @id_Goods ,
	       @id_Creator,
	       @Price,
	       @Number
           
           )

 close cur_cust_id
 DEALLOCATE cur_cust_id
END 
GO

Create Table Receiving
(id_Declare int NOT NULL,
id_Goods int NOT NULL,
id_Creator int NOT NULL,
Price int NOT NULL,
Number int NOT NULL,
primary key (id_Declare, id_Goods)
);