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

9 votes262 views1 answer
No sql
SQL
0 vote283 views1 answer
Oracle string length
SQL
5 votes240 views6 answers
Sql add days to date
SQL
0 vote250 views1 answer
Sql server convert date to weekday
SQL
0 vote292 views2 answers
Insert data mysql with cmd
SQL
0 vote244 views1 answer
Oracle create package body
SQL
0 vote256 views1 answer
Postgres read table structure
SQL
6 votes261 views5 answers
Sql add months to date
SQL
5 votes257 views1 answer
Oracle nls parameters
SQL
0 vote288 views1 answer
Add new column in sql with foreign key
SQL