/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 vote116 views1 answer
How to drop function in sql
SQL
0 vote114 views1 answer
Difference between 2 query results sql server
SQL
12 votes151 views6 answers
Distinct in sql server
SQL
1 vote109 views1 answer
Mysql show current queries
SQL
1 vote121 views1 answer
SQL: merging multiple row data in string
SQL
0 vote130 views1 answer
Safe mysql
SQL
0 vote119 views1 answer
OFFSET consulta mysql
SQL
0 vote116 views1 answer
Alasql delete column
SQL
1 vote119 views1 answer
Mysql get domain from url
SQL
0 vote132 views1 answer
Recently updated stored procedure in sql server
SQL