SQL SELECT multi-columns INTO multi-variable

sql sql-server teradata
ala picture ala · Aug 27, 2009 · Viewed 130.8k times · Source

I'm converting SQL from Teradata to SQL Server

in Teradata, they have the format 

SELECT col1, col2
FROM table1
INTO @variable1, @variable2

In SQL Server, I found 

SET @variable1 = (
SELECT col1 
FROM table1
);

That only allows a single column/variable per statement. How to assign 2 or more variables using a single SELECT statement?

Answer

David M picture David M · Aug 27, 2009 
SELECT @variable1 = col1, @variable2 = col2
FROM table1

Related questions

Left join without multiple rows from right table

I have two tables (User and Salary). I want to do a left join from User to Salary. For each user I want their name and salary. In case they have no salary that field can be left empty. So …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More