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 vote223 views3 answers
Getdate function in postgresql
SQL
0 vote286 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote221 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote203 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote180 views2 answers
Postgresql could not start server mac
SQL
0 vote242 views1 answer
Fetching data from mysqldb
SQL
0 vote206 views1 answer
Oracle archivemode
SQL
0 vote232 views1 answer
Mysql best varchar length size
SQL
4 votes213 views1 answer
Sql delete where in select
SQL
1 vote215 views1 answer
How to drop function in sql
SQL