MS SQL: How to display table name in SELECT query?

Question

SQL Server

In the command , the SELECT * FROM tableresult will be the entire table, but without a title. How to make it so that there is a name?
Tried

SELECT Product AS N'товары'
FROM Mytable AS N'таблица товаров'

..but swears at the syntax in line 2

Answer 1

SELECT 1, 'таблица товаров'
UNION
SELECT 2, Product AS 'товары' FROM Mytable
ORDER BY 1, 2