Select into table variable

DECLARE @userData TABLE(
    name varchar(30) NOT NULL,
    oldlocation varchar(30) NOT NULL
);

INSERT INTO @userData (name, oldlocation)
SELECT name, location FROM myTable
INNER JOIN otherTable ON ...
WHERE age > 30;

Similar codes

12 votes201 views4 answers
Psql command not found
SQL
0 vote186 views1 answer
Execute sql stored procedure in powershell
SQL
10 votes187 views4 answers
Primary key sql
SQL
0 vote181 views4 answers
First max salary in sql
SQL
16 votes190 views4 answers
Mysql import from sql file
SQL
0 vote184 views1 answer
Group_concat only returns one row
SQL
0 vote204 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
19 votes186 views2 answers
Mysql tinyint max value
SQL
0 vote177 views1 answer
Console output pl sql
SQL
0 vote181 views1 answer
Case when with count and combining similar values in sql
SQL