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 vote166 views1 answer
C# sql transaction multiple connections
SQL
0 vote141 views1 answer
How to find database collation in postgres
SQL
1 vote239 views1 answer
Mysql data from file
SQL
1 vote130 views1 answer
Sql dcl
SQL
0 vote144 views1 answer
Tsql table column constraint must be uppercase
SQL
-1 vote132 views1 answer
Mysql #1064 error
SQL
0 vote132 views1 answer
Create table if not exist with exceptions
SQL
0 vote142 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
-1 vote133 views5 answers
Online sql to linq generator
SQL
6 votes147 views3 answers
Sql select last id
SQL