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 vote167 views1 answer
Minecraft duping allowed servers
SQL
0 vote160 views1 answer
Get created time of database psql 8
SQL
0 vote197 views1 answer
Sql server phone constraint
SQL
0 vote178 views2 answers
Athena drop partition
SQL
0 vote155 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote185 views1 answer
How to find total working hour in sql
SQL
0 vote187 views1 answer
How to read the potentail error messages in ssis package
SQL
23 votes190 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote186 views1 answer
Sql get count without group by
SQL
0 vote181 views1 answer
I wanted to select among the rows the highest value in mysql
SQL