DECLARE @TableDemo TABLE(
ProductId INT IDENTITY(1,1),
ProductName VARCHAR(150)
)

INSERT INTO @TableDemo (ProductName) VALUES('Chai'),('Chan'),('Aniseed Syrup')

SELECT 'Producto'+ CAST(ProductId as varchar(10))+' :' +ProductName AS ProductName
FROM @TableDemo