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

8 votes102 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote100 views1 answer
Sql convert datetime to year
SQL
0 vote95 views1 answer
User defined variables in sql
SQL
5 votes101 views4 answers
Describe table postgres
SQL
5 votes106 views2 answers
Mysql drop table cascade
SQL
0 vote106 views1 answer
Odd record sql query
SQL
1 vote106 views1 answer
Raw query must include primary key
SQL
17 votes96 views4 answers
Show tables sql server
SQL
0 vote107 views1 answer
Like date sql server not working
SQL
58 votes262 views6 answers
Create new user in postgres
SQL