/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 vote123 views1 answer
How to use query in nosql
SQL
12 votes144 views5 answers
Sql primary key
SQL
3 votes128 views1 answer
How to check schema privileges in oracle
SQL
0 vote136 views1 answer
Hour and minute between two datatime sql
SQL
0 vote118 views1 answer
SQL Server format datetime
SQL
0 vote172 views1 answer
Insert into table with only identity column
SQL
0 vote147 views1 answer
Function plsql
SQL
0 vote126 views1 answer
Sql datediff db2
SQL
0 vote145 views1 answer
PSQL use LIKE with timestamps
SQL
7 votes127 views1 answer
Oracle set sequence value to max(id)
SQL