/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 vote107 views2 answers
How to check if sqlite table exists in nodejs
SQL
13 votes114 views4 answers
Mysql get last row
SQL
0 vote112 views1 answer
Sauvegarde complète my sql
SQL
0 vote112 views1 answer
Mac os zsh: command not found: mysql
SQL
-1 vote124 views1 answer
Minus vs except in sql
SQL
0 vote127 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote120 views1 answer
Mysql date format unix timestamp
SQL
7 votes127 views1 answer
Xampp reset mysql
SQL
0 vote121 views1 answer
MySql Modify Increment
SQL
4 votes131 views1 answer
Postgres delete last row
SQL