sql server - Assign multiple Variables at once as result from Select Statement -

sql server - Assign multiple Variables at once as result from Select Statement -

due runtime want asign columns of single-row-resultset multiple variables @ 1 time in sql-server stored procedure. want replace lastly 2 lines of next code:

declare @a int declare @b int select @a = (select col1 table1 id=1234) select @b = (select col2 table1 id=1234)

since in version programme search twice id=1234 want like

select @a, @b = (select col1, col2 table1 id=1234)

but can't figure out right syntax this.

you can this

select @a =col1,@b=col2 table1 id=1234

sql-server tsql