USE [Database]

IF OBJECT_ID('[Procedures].[update_product_inflow_record]', 'P') IS NOT NULL
  DROP PROCEDURE [Procedures].[update_product_inflow_record];
GO
CREATE PROCEDURE [Procedures].[update_product_inflow_record]
  @product_inflow_record_id     AS INT,
  @barcode_product_value_id     AS INT,
  @supplier_id                  AS INT,
  @count                        AS INT,
  @full_price                   AS INT,
  @datetime                     AS DATETIME
AS
  UPDATE [Tables].[product_inflow_records]
  SET
    [barcode_product_value_id] = @barcode_product_value_id, 
	[supplier_id] = @supplier_id,
	[count] = @count,                       
	[full_price] = @full_price,                  
	[datetime] = @datetime
  WHERE [id] = @product_inflow_record_id;
GO