/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

20 votes281 views1 answer
Sql change column types
SQL
0 vote276 views1 answer
Returning with sqlalchemy
SQL
10 votes262 views6 answers
Between sql
SQL
12 votes300 views1 answer
Run mysql instance in docker
SQL
3 votes224 views2 answers
Mysql sum with condition
SQL
0 vote308 views1 answer
Typical max-connect-errors mysql
SQL
0 vote257 views1 answer
Difference between cross apply and inner join
SQL
0 vote264 views1 answer
Sub query in linq
SQL
1 vote288 views2 answers
Foreign key set 0
SQL
0 vote306 views1 answer
Select * from mysql.proc
SQL