mssql select into multiple variables Edit

Murugan Andezuthu Dharmaratnam | 28 November 2020 | 257

MSSQL how to select into multiple variables in mssql select statement. Or how to assign values to two or more variables using a single statement

Solution

select @variable1 = col1, @variable2 = col2
from table