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

1 vote293 views1 answer
Oracle create as select
SQL
0 vote294 views1 answer
Transaction database with php
SQL
0 vote276 views1 answer
Mysql command line ubuntu
SQL
0 vote312 views1 answer
Query builder doctrien return sql
SQL
0 vote275 views3 answers
Sql select statements
SQL
7 votes291 views2 answers
Sql empty table
SQL
-1 vote279 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote320 views1 answer
Drop view in mysql
SQL
0 vote321 views1 answer
Mysql backup query
SQL
0 vote279 views1 answer
Creation d'un trigger sql
SQL