/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 vote209 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote249 views1 answer
Sql query inline if
SQL
4 votes274 views1 answer
How to check last gather stats on table in oracle
SQL
36 votes216 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote220 views1 answer
Sql avg group by
SQL
-1 vote235 views1 answer
Select first rows postgresql
SQL
1 vote213 views1 answer
Deleting database in sql
SQL
15 votes226 views4 answers
Create table if not exists sql
SQL
1 vote230 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote219 views1 answer
Mysql conf.d exampel
SQL