/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 vote376 views2 answers
SQL FROM
SQL
0 vote350 views2 answers
How to get json data mysql
SQL
2 votes351 views3 answers
Oracle show column of table
SQL
0 vote375 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote408 views1 answer
Find and replace query in wordpress\
SQL
1 vote347 views1 answer
Oracle finding duplicate records
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL
2 votes353 views2 answers
Run mysql command from bash
SQL
2 votes413 views1 answer
Pdo mysql insert
SQL
1 vote340 views1 answer
Oracle db create new schema
SQL