Hi nauna,

As per your explanation it is not possible with trigger. You can create procedure or function.

Refer the below sample query.

CREATE PROC GetPrice
	@ItemId INT
AS
BEGIN
	-- Variable Table Start 
	DECLARE @PriceTable AS TABLE(itemid INT,price INT)
	INSERT INTO @PriceTable VALUES(1,90)
	INSERT INTO @PriceTable VALUES(2,10)
	INSERT INTO @PriceTable VALUES(3,120)
	-- Variable Table End
	 
	IF EXISTS(SELECT * FROM @PriceTable WHERE itemid = @ItemId)
		BEGIN
			SELECT 'item is valid'
		END
	ELSE
		BEGIN
			SELECT 'Invalid'
		END
END

To learn trigger refer below article.

SQL Server: Get Inserted, Updated and Deleted Row values in Insert, Update and Delete Triggers