Table variable in SQL Server

Let's have a preview of this amazing thing that is the Table variable in SQL Server.

Basic syntax

DECLARE @DevExperts TABLE
(Id INT PRIMARY KEY IDENTITY(1,1),
Name VARCHAR(MAX),
Country VARCHAR(MAX))

The column Id is defined to be the primary key and to iterate automatically.

Basic insert

INSERT INTO @DevExperts VALUES 
('Ada Lovelace', 'Uk'),
('Evelyn Boyd Granville', 'US'),
('Carol Shaw', 'US'),
('Adi Polak', 'global'),
('Trisha Gee', 'Spain'),
('Mala Gupta', 'India')

SELECT * FROM @DevExperts

The output is