The first day of SQL Learning -- SQL defines variables as tables (Virtual tables)

SQL defines variables as the Table Type
When defining variables in SQL statements, we often define variables like char, varchar, nvarchar, int ........, so how to make a variable as a virtual table is actually very simple.

Basic Syntax:
Copy codeThe Code is as follows:
Declare @ t table (Data Type 1 in column 1, data type 2 in column 2 ,...............)
Insert into @ t (column name 1, column name 2 ,...............) values (...............)
[Code]
Or
[Code]
Insert into @ t (column name 1, column name 2,...) (select... from ....)

Experiment Table 1 (PeopleInfo ):
Id name phone
XC1 Lee 123333333
XC2 small 785555555
For example:
Copy codeThe Code is as follows:
Declare @ t table (id nvarchar (3), [name] nvarchar (10 ))
Insert into @ t (id, [name])
(Select id, [name] from PeopleInfo where [Name] like 'Li % ')
Select * from @ t

Result:
Id name
XC1 Li