/SQL/Store select query result in variable sql server

Store select query result in variable sql server

DECLARE @result1 TABLE (a INT, b INT, c INT)

INSERT INTO @result1
SELECT a, b, c
FROM table1

SELECT a AS val FROM @result1
UNION
SELECT b AS val FROM @result1
UNION
SELECT c AS val FROM @result1

Source: stackoverflow.com

Similar codes

1 vote375 views1 answer
Sql server if exists update else insert
SQL
2 votes339 views1 answer
Mysql Incorrect column specifier for column
SQL
4 votes357 views3 answers
Sql drop database if exists
SQL
3 votes326 views2 answers
How to View column names of a table in SQL
SQL
10 votes329 views6 answers
Between sql
SQL
0 vote331 views1 answer
Drop all tables db2
SQL
0 vote334 views1 answer
Equi joins in oracle
SQL
5 votes336 views2 answers
Oracle rename table
SQL
8 votes322 views1 answer
Alter tablespace add datafile
SQL
1 vote332 views1 answer
Create sqlite database in laravel
SQL