/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 vote154 views1 answer
Mysql 8 error on identified by
SQL
6 votes140 views2 answers
Mysql concatenate two columns into one
SQL
6 votes155 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote149 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote563 views1 answer
How to lock table in mysql
SQL
15 votes160 views6 answers
Laravel db transaction
SQL
0 vote258 views1 answer
Python get backup of sql
SQL
0 vote151 views1 answer
How to put is null in where in clause
SQL
2 votes143 views1 answer
Select * from table where name like
SQL
3 votes162 views1 answer
Oracle limit user tablespace
SQL