SQL Tech Insider-3---Variable declaration method similar to Temporal table usage

-----directly on the code

--Declares a variable of type table declare @table table (name varchar, name2 varchar (500))--Raw data SELECT * FROM dbo. Customers-Inserts the data into the temporary variable insert into @table SELECT * from  dbo. Customers--The data in the variable select * from @table

-Results---

--Raw data

CustomerID City
Fissa Madrid
Frndo Madrid
Krlos Madrid
Mrphs Zion

---data in a variable

Name Name2
Fissamadrid
Frndomadrid
Krlosmadrid
Mrphszion

---The following method of using temporary tables, the result is the same

CREATE  TABLE #temp (name varchar, name2 varchar)  SELECT * FROM dbo. Customers INSERT into #temp SELECT * from  dbo. Customers SELECT * from #tempDROP TABLE #temp

　　

SQL Tech Insider-3---Variable declaration method similar to Temporal table usage