/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 vote180 views1 answer
Sql server Cost Fifo query
SQL
0 vote171 views1 answer
Casterar postgres
SQL
5 votes164 views1 answer
Oracle find foreign key dependencies
SQL
3 votes164 views1 answer
Sql server check version
SQL
0 vote158 views1 answer
Sql replace id with name from another table
SQL
0 vote174 views1 answer
Sql server concat null
SQL
0 vote165 views1 answer
Events not working db
SQL
1 vote167 views1 answer
Postgresql datetrunc too slow
SQL
1 vote173 views3 answers
Connection string mysql
SQL
0 vote182 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL