/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 vote140 views1 answer
Sqlite check if row exists
SQL
0 vote140 views1 answer
Microsoft word insert sql code
SQL
50 votes199 views6 answers
Sql duplicate rows
SQL
0 vote159 views1 answer
Mysql insert into select transaction c#
SQL
22 votes137 views4 answers
Show list of users in mysql
SQL
0 vote153 views1 answer
Allow null in psql
SQL
0 vote168 views1 answer
How to pass list as parameter in SQL query
SQL
1 vote123 views1 answer
Tsql update datetime
SQL
7 votes132 views3 answers
How to check table name in current database sql
SQL
3 votes152 views1 answer
Oracle cannot access v$session
SQL