SQL

CREATE PROCEDURE UpdateProduct 	@ProductID int, 	@BrandName varchar(255), 	@ProductName varchar(255), 	@SRP decimal(10,2), 	@GrossWeight decimal(10,2), 	@NetWeight decimal(10,2), 	@ShelfWidth decimal(10,2), 	@ShelfHeight decimal(10,2), 	@ShelfDepth decimal(10,2), 	@LastUpdated binary(8) AS	DECLARE		@RowCount int	BEGIN		SET @RowCount = 0		UPDATE Products		SET BrandName = @BrandName,			ProductName = @ProductName,			SRP = @SRP,			GrossWeight = @GrossWeight,			NetWeight = @NetWeight,			ShelfWidth = @ShelfWidth,			ShelfHeight = @ShelfHeight,			ShelfDepth = @ShelfDepth		WHERE ProductID = @ProductID		AND LastUpdated = @LastUpdated		SET @RowCount = @@RowCount		SELECT @RowCount AS "RowCount"		ENDGO