/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

2 votes168 views1 answer
Oracle log files
SQL
0 vote167 views1 answer
Drop domain postgresql
SQL
1 vote209 views1 answer
Oracle create program if not exists
SQL
0 vote139 views1 answer
Update view sql
SQL
9 votes136 views1 answer
Oracle get table schema
SQL
0 vote141 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote134 views2 answers
Mysql decimal remove trailing zeros
SQL
17 votes134 views3 answers
Cast in sql server
SQL
10 votes135 views1 answer
Oracle dba_dependencies
SQL
0 vote139 views1 answer
How to connect to mysql in ef 6
SQL