Table Variables vs Temp Tables

TableVarVsTempTable.sql

-- Naming: 
--  #TableName : local temp table
--  ##TableName: global temp table
--  @TableName: table variable
--  TableName: permanent table

CREATE TABLE #Employees 
( 
    Name varchar(30),
    Age INT
) 
 
INSERT INTO #Employees VALUES ('Sina', 29), ('Rhys', 28), ('Scott', 50)
 
SELECT * FROM #Employees
 
-- temp tables should be dropped in the end
DROP TABLE #Employees

GO


DECLARE @people TABLE 
( 
    Name varchar(30),
    Age INT
) 
 
INSERT INTO @people VALUES ('Sina', 29), ('Rhys', 28), ('Scott', 50)
 
SELECT * FROM @people
 

GO