/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 vote303 views2 answers
Default constraint in ms sql
SQL
0 vote581 views1 answer
How to connect .sql data set to powerbi
SQL
2 votes310 views4 answers
Mysql get all tables row count
SQL
3 votes283 views3 answers
Into in sql
SQL
0 vote345 views1 answer
Delete from IN subquery
SQL
0 vote285 views1 answer
RowDataPacket
SQL
11 votes318 views3 answers
Sql line numbers
SQL
1 vote316 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote295 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
1 vote300 views1 answer
Blob datatype in mysql
SQL