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

0 vote173 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote149 views1 answer
If null don't update
SQL
15 votes159 views2 answers
Select Options
SQL
0 vote187 views1 answer
Sql server sleep
SQL
6 votes161 views1 answer
Postgres get size of database
SQL
1 vote196 views1 answer
Oracle apex version view
SQL
0 vote152 views1 answer
How to select only a certain date sql
SQL
1 vote136 views3 answers
Grant syntax in sql
SQL
23 votes163 views3 answers
Sql where contains part of string
SQL
2 votes180 views2 answers
Calculate percentage in sql
SQL