/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 vote191 views1 answer
Mssql check if date is greater than today
SQL
0 vote178 views2 answers
Postgres default user
SQL
0 vote182 views1 answer
MySql count occurences more than"
SQL
0 vote180 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote219 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote174 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
1 vote153 views2 answers
Delete auto increment mysql
SQL
4 votes183 views2 answers
Mysql select where starts with
SQL
0 vote190 views1 answer
Sqlite3_open_v2
SQL
1 vote242 views1 answer
Create index concurrently postgres
SQL