/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 vote329 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote345 views1 answer
How to remove identity from a column in sql server
SQL
0 vote358 views1 answer
Sql date with year
SQL
0 vote341 views3 answers
Select random sql
SQL
0 vote385 views1 answer
Wordpress make wp user in db
SQL
1 vote316 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote333 views1 answer
Sql server concat null
SQL
0 vote334 views1 answer
Mysql count unique in group statement
SQL
0 vote386 views1 answer
Sql check if field is not null
SQL
3 votes308 views3 answers
Mysql select table names
SQL