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

1 vote331 views1 answer
Mysql select if empty result
SQL
12 votes335 views6 answers
Select distinct
SQL
0 vote309 views1 answer
Ms Sql set us timezone
SQL
1 vote339 views1 answer
Sql group by sum with condition
SQL
1 vote331 views2 answers
Changes not showing on website server odoo
SQL
1 vote307 views1 answer
Oracle current sequence value
SQL
1 vote339 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote376 views1 answer
Oracle pl/sql check if file exists
SQL
10 votes338 views4 answers
How to alter table name in mysql
SQL
0 vote324 views1 answer
Check duplicate values plsql
SQL