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 vote210 views1 answer
Reutrn string after character sql
SQL
1 vote236 views1 answer
Rails run native ssql query
SQL
0 vote231 views1 answer
Postgres statistics
SQL
0 vote237 views1 answer
Postgresql on conflict pair
SQL
0 vote227 views1 answer
Datagrip go to line
SQL
3 votes236 views2 answers
Oracle drop column
SQL
5 votes246 views3 answers
Show indexes mysql
SQL
7 votes214 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote222 views1 answer
How to print out column name differently in mysql
SQL
0 vote230 views1 answer
Create sql table from script inline primary key constraint
SQL