The information that is queried often needs to be saved for use. When querying data with a SELECT statement, you can set the data to be stored in a newly created table or in a variable.
10.6.1 store query results into tables
Use SELECT ... Into statements can store the results of a query in a newly created database or temporary table. If you want to store the query results in a table instead of a temporary table, use the Select ... into a statement should determine that the database that stores the table "Select Into/bulk Copy" option is set to "true/on", otherwise it can only be stored in a temporary table.
10.6.2 Store query results into variables
At some point, we need to use the results of a query in a program, such as when writing a stored procedure or trigger, where we need to store the results of the query in a variable.
See the full set of "MS SQL Basics Tutorials"