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 vote131 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote126 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote139 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote140 views1 answer
How to update sql server version
SQL
0 vote149 views1 answer
Xamarin sql lite create table if not exist
SQL
9 votes129 views1 answer
Sql server get utc date
SQL
2 votes131 views1 answer
Check isolation level in mysql
SQL
0 vote127 views1 answer
Convert rows to columns in sql server
SQL
2 votes130 views1 answer
Sql update \
SQL
1 vote143 views1 answer
Find difference in dates sql
SQL