/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 vote252 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote268 views1 answer
Watch mysql command line
SQL
8 votes251 views1 answer
Mysql restore database
SQL
14 votes274 views4 answers
Sql compiler
SQL
20 votes273 views6 answers
Change password in mysql
SQL
0 vote268 views1 answer
Materialized view redshift
SQL
0 vote243 views1 answer
Sum value by month sql
SQL
0 vote245 views1 answer
Update set with inner join oracle
SQL
0 vote253 views1 answer
Inner join distinct
SQL
0 vote251 views1 answer
How to use group_concat in sql server
SQL