/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

16 votes305 views1 answer
Sqlserver add column to table
SQL
1 vote275 views2 answers
Sql server add time to date
SQL
1 vote277 views1 answer
Drop column if exists sql server
SQL
0 vote282 views1 answer
Sql select column name like from multiple tables
SQL
0 vote323 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote262 views1 answer
Postgres declare variable
SQL
1 vote282 views1 answer
Round one decimal place mysql
SQL
0 vote273 views1 answer
Mysqli last row
SQL
1 vote266 views4 answers
Sql now
SQL
0 vote265 views1 answer
Sql trigger to call stored procedure with parameters
SQL