/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
Oracle last user logon
SQL
1 vote222 views2 answers
Oracle leftmost characters
SQL
3 votes210 views1 answer
Oracle sql commit example
SQL
0 vote213 views2 answers
Sqlalchemy core in clause
SQL
0 vote168 views1 answer
Delete all rows from table sqlite
SQL
0 vote195 views2 answers
How to see table associated with a schema in sql
SQL
0 vote162 views1 answer
Copy table dbeaver
SQL
0 vote191 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
5 votes203 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote200 views1 answer
Oracle job session
SQL