-----------------------
--- Table variables ---
-----------------------

-- * Table variables were introduced in SQL Server 2000.
-- * A table variable is created in tempdb.
-- * The table can have constraints (PK, Null, Unique..), but no indexes or statistics.
-- * A Table variable is like an “array”

DECLARE @tab TABLE
(
Id INT,
Name VARCHAR(50)
)

--select * from @tab

-- Insert Values 
INSERT INTO @tab VALUES (1, 'Nick')
INSERT INTO @tab VALUES (2, 'James')
INSERT INTO @tab VALUES (3, 'Keren')
INSERT INTO @tab VALUES (4, 'Joe')

-- Print Values 
SELECT * FROM @tab WHERE id = 1 
-- Or
SELECT * FROM @tab WHERE id = 2 

-- Delete Values 
DELETE FROM @tab WHERE id = 3 
SELECT * FROM @tab WHERE id = 3 


DECLARE @prod_tab TABLE
(
prod_id int, 
prod_name varchar(35)
)

INSERT INTO @prod_tab 
SELECT productID , productName FROM products 

SELECT * FROM @prod_tab WHERE prod_id = 3