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

4 votes293 views2 answers
Float postgres
SQL
8 votes261 views2 answers
Mysql query dates between two dates
SQL
0 vote273 views1 answer
Sql order by number not ordered
SQL
1 vote276 views1 answer
Get last week data in mysql
SQL
6 votes273 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote306 views1 answer
Sql cursor example multiple columns
SQL
0 vote258 views1 answer
Oracle drop default value
SQL
0 vote343 views1 answer
Sqlite display headers on columns
SQL
5 votes293 views4 answers
Upload database mysql command line
SQL
2 votes278 views2 answers
Postgres select duplicate columns
SQL