/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 vote152 views1 answer
Sql drop with dependencies
SQL
5 votes166 views4 answers
Upload database mysql command line
SQL
0 vote175 views1 answer
Sql mod even odd
SQL
1 vote204 views1 answer
Sql query row number group by
SQL
3 votes155 views3 answers
Into in sql
SQL
2 votes146 views1 answer
Rails execute sql
SQL
0 vote151 views1 answer
Show create table in postgresql
SQL
1 vote187 views1 answer
Sql to mongodb query converter
SQL
3 votes302 views6 answers
Sql unique select
SQL
0 vote142 views1 answer
Dump only schema
SQL