/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

7 votes210 views2 answers
MySQL IF without else
SQL
1 vote191 views1 answer
Does insert into overwrite sql
SQL
0 vote195 views1 answer
Sql server insert inner join
SQL
0 vote215 views1 answer
Mssql unique key accept nulls
SQL
0 vote208 views1 answer
Mysql subdate
SQL
4 votes219 views2 answers
Float postgres
SQL
0 vote207 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote210 views1 answer
Write a query to peint the pattern P(20)
SQL
1 vote183 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote176 views1 answer
Delete triger pl pg sql
SQL