/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

0 vote102 views1 answer
Formatting code with SQL Developer
SQL
3 votes115 views1 answer
Select sequence oracle
SQL
1 vote190 views1 answer
Mysql breakline on string
SQL
0 vote102 views1 answer
Oracle dynamic select into
SQL
0 vote95 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote102 views1 answer
Mysql add to number
SQL
0 vote98 views1 answer
Acutal month year
SQL
15 votes106 views4 answers
Mysql where value is null
SQL
0 vote108 views1 answer
Except in sql
SQL
0 vote120 views1 answer
Sql server for loop
SQL