/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

2 votes168 views1 answer
Sql server find table name
SQL
0 vote188 views1 answer
Vs 2019 connect to local mysql database
SQL
6 votes186 views2 answers
Drop foreign key
SQL
0 vote194 views1 answer
Sql server convert to guid
SQL
0 vote211 views1 answer
Error code 1451 sql
SQL
10 votes182 views1 answer
User_dependencies
SQL
15 votes187 views2 answers
How to know the username of postgresql
SQL
0 vote188 views1 answer
Php get closest location by latitude longitude
SQL
2 votes190 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
3 votes189 views4 answers
Postgresql change timezone on timestamp without timezone
SQL