/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 vote148 views1 answer
Sqlite insert or update
SQL
0 vote129 views1 answer
Compare field sql server
SQL
0 vote154 views2 answers
Return the number of records in a single table mysql
SQL
0 vote137 views1 answer
2020 new year
SQL
6 votes151 views3 answers
Mysql create database utf8
SQL
2 votes144 views1 answer
Columns Present in a table
SQL
0 vote172 views1 answer
Insert output identity
SQL
8 votes144 views3 answers
Postgres connection string
SQL
1 vote140 views1 answer
User privileges postgresql information_schema
SQL
0 vote142 views1 answer
To change the database owner in SQL server
SQL