how to create temporary table in sql using query code example

Example: tsql create temp table

CREATE TABLE #haro_products (
    product_name VARCHAR(MAX),
    list_price DEC(10,2)
);